Latest Posts From Rifat Hassan
Many a time while working with VBA in Excel, we need to remove the duplicates from an array. In this article, I’ll show you how you can remove duplicates from ...
Rifat Hassan
Not only in Excel VBA but also while working with almost all the programming languages, we often need to generate one or more random number (s) in between a ...
In this article, I’ll show you how you can add a hyperlink to a cell in another sheet using VBA in Excel. Excel VBA: Add Hyperlink to Cell in Another ...
In this article, I’ll show you how you can get the cell value by row and column from a worksheet in Excel VBA. You’ll learn to get the cell value from the ...
In this article, I’ll show you how to pull data from multiple worksheets into one worksheet with Visual Basic of Applications (VBA) in Excel. Pull Data ...
While working with VBA in Excel, we often need it for iterating through each row of a range in a worksheet. In this article, I’ll show you how you can use ...
In this article, I’ll show you how you can sort multiple columns of a table using VBA in Excel. You’ll learn to sort all the columns of a table based on both a ...
In this article, I’ll show you how you can insert an image into a cell with Excel VBA. Insert an Image into a Cell with Excel VBA (Quick View) Sub ...
In this article, I’ll show you how you can remove the duplicate values from a drop down list of a worksheet in Excel with the help of VBA and keep only the ...
Counting the unique values in a column is one of the major features that’s used quite often while working in both Excel and VBA. In this article, I’ll show you ...
To insert one or more formulas with relative cell references is one of the most important and widely used features that we encounter every day while working ...
While working with VBA in Excel, we often need to delete a row if any cell is blank. In this article, I’ll show you how you can delete a row if a cell is blank ...
While working with VBA in Excel, we often need to copy only values from a range of cells to a destination range. In this article, I’ll show you how you can ...
One of the most common problems that we encounter while working with copying and pasting in Excel VBA is the run time error 1004: PasteSpecial Method of Range ...
While working with VBA in Excel, we often have to concatenate string (s) and variable (s) in a worksheet. Concatenating string (s) and variable (s) is widely ...
- « Previous Page
- 1
- 2
- 3
- 4
- 5
- …
- 12
- Next Page »
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?