Latest Posts From Rifat Hassan
When working with Excel, it is a frequent need for us to work with date-type data. Sometimes, we need to put the same date values with the only difference in ...
Rifat Hassan
Often, you may find yourself in a situation where you are working with a large array of data and need to find some unique values or texts but don’t have a ...
This article will focus on how to count date occurrences in Excel from different datasets and different conditions. Excel Count Date Occurrences: 2 ...
In this article, I will be showing how you can find unique values from multiple columns in Microsoft Excel. Find Unique Values from Multiple Columns in ...
We use numbers in Excel in different cases. In those cases, we may get numbers with long decimals. But in most real cases, those long decimals are not that ...
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. ...
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 copy ...
While working in Excel, we often have to add leading zeros before one or more numbers in Excel. This is in fact quite easy to implement. Today I will be ...
In this article, we will show you two quick methods for how to use the INDEX and MATCH functions for multiple criteria without an array in Excel. Two of the ...
While working with dates in Excel, we often have to insert a large number of dates as input. It is quite troublesome to sit down and insert so many dates ...
While working with dates in Microsoft Excel, sometimes users have to differentiate some data based on their dates. It is good practice to change the cell color ...
How to Add Dates in Excel Click on a cell and write any date inside it, in the conventional format, DD/MM/YYYY. Go to the Home and Number ...
Sales growth percentage evaluates a company's capability to earn revenue from sales over a specific time period. Nowadays, Microsoft Excel is a very useful ...
Percentages are one of the most important types of mathematical operations in our lives. Most people understand this operation and use it in their lives. Sales ...
We often have to multiply a column in Excel by a constant while working. We have to perform various types of multiplication like multiplying cells between two ...
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?