Latest Posts From Rifat Hassan
Introduction to the XLOOKUP Function The XLOOKUP function finds a specific value within a range of cells or an array. It then returns the ...
Rifat Hassan
Download Practice Workbook Performing Vlookup with Multiple Matches.xlsx Step 1 - Create Unique Name for Each Lookup Value Insert a new column ...
Method 1 - Applying the VLOOKUP Function to Search for Specific Text in Excel We can use partially matched text to find data from a range of cells in Excel. ...
Introduction to Fuzzy Match A Fuzzy Match is a type of partial match. In these types of matches, one text does not match fully to the other ...
This is the sample dataset. Method 1 - Counting the Exactly Matched String Steps: Create four extra fields. To count how many times the ...
We have a data set with the Names, Authors, and Book Types of some books from a bookshop named Martinez Bookstore. We'll look for a partial text match within ...
An Introduction to Excel’s VLOOKUP Function =VLOOKUP(lookup_value,table_array,col_index_num,) This function takes a range of cells called table_array ...
We have three worksheets in a workbook. They contain the sales records of some items over January, February and March, respectively. We'll pull data from these ...
Introduction to the IF Function in Excel ⇒ Syntax =IF(logical_test, , ) ⇒ Function Objective Determines if a condition is TRUE or FALSE, then ...
The sample dataset showcases Names, Marks in Mathematics, and students' Grades. There are 6 different grades. A+, A, A-, B, C, and F. They ...
Method 1 - Applying Sort & Filter Feature to Sort by Date in Excel Steps: Select the whole data set by selecting cells B4:D19. Go to the Home tab. ...
An Overview of the SORT Function in Excel: Introduction to the SORT Function in Excel: Syntax and Arguments ⦿ Objective: Sorts a given range of ...
We will use a dataset that includes Items Produced in 2021 and Items Produced in 2022 of a company. Method 1 - Sort Two Columns to Match with ...
Consider the following dataset. We have the Employee IDs, Employee Names, Joining Dates, and Salaries of a company. We will lookup values with multiple ...
While working with Excel VBA codes, we come across a few built-in functions that convert a complex task into a small one-line code. InStr is such a function ...
See Our Reviews at
Hi Tim, thank you for your valuable response. You can declare the variables this way:
Dim File_Dialog as FileDialog
Set File_Dialog = Application.FileDialog(msoFileDialogFolderPicker)
Dim Sheet_Names(2) as Variant
Sheet_Names(0)=”Sheet1″
Sheet_Names(1)=”Sheet2″
Sheet_Names(2)=”Sheet3″
Dim New_File(2) as Variant
New_File(0)=”New_Sheet1″
New_File(1)=”New_Sheet2″
New_File(2)=”New_Sheet3″
But declaring variables beforehand is not mandatory in VBA. You can directly assign values to them as mentioned in the given codes.
Hi Nico,
Thanks for your response. You can use the FILTER function of Excel for your problem. Check this article for details https://www.exceldemy.com/excel-filter-multiple-criteria/.
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.
Hi Arjun, the codes are absolutely flawless and there is no reason for them to not work properly. Did you insert the inputs correctly?
Hi Luis,
Thank you for your response. Hope this comes in handy for more people like you.
Hello Sam,
Thank you Sam for your response. It’s working fine now. Thank you again.
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.
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.
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:
Sub Add_Empty_Row()
Dim ws As Worksheet
Set ws = ActiveSheet
Dim tbl As ListObject
Set tbl = ws.ListObjects(“Table1”)
tbl.ListRows.Add
End Sub
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.
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?