User Posts: Rifat Hassan
0
Excel VBA: Turn Off Screen Update
0

It’s an important issue for all of us while working with VBA in Excel, to turn off the screen update. In this article, I’ll show you how you can turn off the ...

0
Excel VBA: Check If a Sheet Exists (2 Simple Methods)
0

One of the many things that we can accomplish using VBA in Excel is that we can check if a particular sheet exists in a workbook or not. In this article, I’ll ...

0
How to Write to a Text File Using Excel VBA
0

In this article, I’ll show you how you can write to a text file using VBA in Excel. How to Write to a Text File Using Excel VBA (Quick View) Sub ...

0
How to Save a Worksheet as a New File Using Excel VBA
0

One of many great uses of Excel VBA in our day-to-day life is that we can use it to save a worksheet as a new Excel file by running just a few lines of code. ...

0
Excel VBA: Check If a File Exists or Not
0

One of the most advantageous uses of Excel VBA in our day-to-day life is that we can check if a file exists on our machine or not using it. In this article, ...

0
Excel VBA: Round to Nearest 5 (Macro and UDF)
0

While working with data sets in VBA in Excel, we often need to round a single value or a set of values to the nearest 5. In this article, I’ll show you how you ...

0
How to Extract Data from PDF to Excel Using VBA
0

It’s a common problem that most of us face in our daily lives is how to extract some data from a PDF file to an Excel worksheet using VBA. In this article, ...

0
How to Automate Excel Reports Using Macros (3 Easy Ways)
0

In this article, I’ll show you how you can automate your Excel reports in the offices using Macros. Automate Excel Reports Using Macros (Quick View) ...

0
Excel Macro: Send Email to an Address in Cell (2 Easy Ways)
0

In this article, I’ll show you how we can develop a Macro to send an email to an address from a cell in a worksheet in Excel. Excel Macro to Send Email ...

0
How to Open All Excel Files in a Folder and Copy Data Using VBA
0

In this article, I’ll show you how you can open all the Excel files from a folder and copy data from them using VBA. Open All Excel Files in a Folder ...

0
Excel VBA: Protect and Hide Formulas
0

In this article, I’ll show you how you can protect and hide formulas with Excel VBA on an Excel worksheet with password. Excel VBA: Protect and Hide ...

0
Excel VBA: Protect Sheet with Password and Allow Filter
0

In this article, I’ll show you how can protect an Excel sheet with a password and also allow the filter there using VBA. Excel VBA: Protect Sheet with ...

0
How to Apply Macro to Send Email from Excel with Attachment
0

While working with Exel files in our day-to-day lives, we often need to send an Email containing the file as an attachment. In this article, I’ll show how you ...

0
How to Fill Blank Cells with Value Above in Excel VBA (3 Easy Methods)
0

In this article, I’ll show you how you can fill the blank cells within a range in Excel with the value available immediately above using VBA. Fill Blank ...

0
How to Calculate Time Difference in Excel VBA (2 Methods)
0

While working with times with VBA in Excel, we often have to calculate the time difference between two times. In this article, I’ll show you how you can ...

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:

    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

  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?

ExcelDemy
Logo