0

## Return Multiple Values in Excel Based on Single Criteria (3 Options)

Today I am going to show how you can return multiple values based on single criteria in Microsoft Excel. Download Practice Workbook Return Multiple ...

0

## How to Compare Rows in Excel for Duplicates

Today I will be showing how you can compare rows in Excel for finding duplicates. Download Practice Workbook How to Compare Rows in Excel for ...

0

## How to Find the Max Value and the Corresponding Cell in Excel (4 Quick Ways)

Today I will be showing how you can find the max value and the corresponding cell from a set of data in Microsoft Excel. Download Practice Workbook ...

0

## VLOOKUP Max Value in Excel (With Limitations and Alternative Options)

Today I will be showing how you can extract the max (maximum) value from a database using the VLOOKUP function of Microsoft Excel. Download Practice ...

0

## How to Add Dates in Excel Automatically (2 Simple Steps)

Today I will be showing how to add dates automatically in Microsoft Excel. Download Practice Workbook How to Add Dates in Excel Automatically ...

0

## How to Create Automatic Rolling Months in Excel (3 Quick Ways)

Today I will show how you can create a series of automatic rolling months in Excel and then arrange your data according to the series created. Download ...

0

## SUMIF with Multiple Criteria in Column & Row in Excel (Both OR and AND Type)

Today I will be showing how you can calculate the sum in any row or column matching multiple criteria using the SUMIFS() function in Excel. Download ...

0

## How to SUMIF by Month in Excel (With Alternative Options)

Today I will be showing how you can sum data by month using SUMIF() and SUMIFS() functions in Microsoft Excel. Download Practice Workbook How to Sum ...

0

## Index Match Multiple Criteria in Rows and Columns in Excel

Today I will be showing how to sort out cells matching multiple criteria in rows and columns in Microsoft Excel using the INDEXÂ and the MATCH functions. ...

0

## COUNTIF with Multiple Criteria in Different Columns in Excel (Both Single and Multiple Criteria)

Today I will be showing how you can count cells in different columns with multiple criteria in Microsoft Excel using the COUNTIF function. Download ...

0

## How to Count Date Occurrences in Excel

Today I will show how you can count the number of occurrences of a particular day in a range of dates and also count the total number of days in a particular ...

0

## How to Find Unique Values from Multiple Columns in Excel

Today I will be showing how you can extract unique values from multiple columns in Microsoft Excel. Download Practice Workbook How to Find Unique ...

0

## How to Round to Nearest 5 in Excel (3 Quick Ways)

Today I will be showing how you can round any number to its nearest multiple of 5 in Microsoft Excel. Download Practice Workbook How to Round to ...

0

## How to Separate Text and Numbers in Excel (4 Easy Ways)

We often have to separate text and numbers from some data in Excel. Today I will be showing 4 easy ways how you can accomplish that conveniently. ...

0

## 3 Quick Ways to Copy Down Excel Formula without Incrementing

While working in Excel, we often have to copy down one formula to another group of cells without incrementing. Today I will be showing three easy ways to ...

##### Browsing All Comments By: Rifat Hassan
1. Hi Veronika, if your problem isn’t solved yet, you can send the file to my mail or can send an image of your file. I’ll try.

2. Hi Arjun, the codes are absolutely flawless and there is no reason for them to not work properly. Did you insert the inputs correctly?

3. Hi Luis,
Thank you for your response. Hope this comes in handy for more people like you.

4. Hello Sam,
Thank you Sam for your response. It’s working fine now. Thank you again.

5. Hi Mohammed, Thanks for your response. Insert the name of the text and the color code in the 2nd and 3rd lines of the codes directly.

6. Hi Man, Thanks in advance. Can you please tell me where exactly the bug is? I have run the code in every way possible and there evolves no error. I think you couldn’t enter the inputs properly. Please go through the article again and then try. If it still doesn’t work, please tell me what exactly the error is.

7. Hi Dennis,

Thanks for your response. To skip the table name, first, remove the 4th line of the code, that is, Table_Name = InputBox(“Enter the Name of the Table: “).

Then enter the name of the table within the 6th line of the code. For example, if the name of your table is “Table1”, then the line should be: Set tbl = ws.ListObjects(“Table1”).

So the complete code will be:

Dim ws As Worksheet
Set ws = ActiveSheet

Dim tbl As ListObject
Set tbl = ws.ListObjects(“Table1”)

End Sub

8. I think the problem lies in the apostrophes. Use this code instead of yours. It works fine for me.

Sub InsertRowsfromUserInput()
Dim iRow As Long
Dim iCount As Long
Dim i As Long
iCount = InputBox(Prompt:=”How Many Rows to Insert?”)
iRow = InputBox _
(Prompt:=”Where to Insert New Rows? (Enter the Row Number)”)
For i = 1 To iCount
Rows(iRow).EntireRow.Insert
Next i
End Sub

If it still doesn’t work, after pasting the code in the VBA editor, change the apostrophes of the 5th and 7th lines manually. Hope it will work then.

9. Thank you Ana. It’s difficult to give any suggestions without having a glance at the workbook. Would you please kindly share your workbook with me?