User Posts: Rifat Hassan
0
Excel VBA: Get Source Data Range from a Chart (with Quick Steps)
0

In this article, I’ll show you how you can get the source data range from a chart using VBA in Excel. Excel VBA: Get Source Data Range from a Chart ...

0
Excel VBA: If Statement Based on Cell Value (2 Practical Examples)
1

In this article, I’ll show you how you can use an If statement in VBA in Excel based on a cell value. Excel VBA: If Statement Based on Cell Value (Quick ...

1
How to Create a Dynamic Chart in Excel Using VBA (with Easy Steps)
0

In this article, I’ll show you how you can create a dynamic chart in Excel using VBA. Download Practice Workbook Download this practice workbook to ...

0
Excel VBA: Set Variable to a Cell Value (3 Practical Examples)
-1

In this article, I’ll show you how you can set a variable to a cell value using VBA in Excel. You’ll learn to set a variable to the value of a single cell and ...

0
Excel VBA: Open Source QR Code Generator
-1

In this article, I’ll show you how to use Excel VBA as an open-source QR code generator. Excel VBA: Open Source QR Code Generator (Quick View) Function ...

0
Excel VBA: Track If a Cell Value Changes
0

In this article, I’ll show you how you can track if a cell value changes in a worksheet using VBA in Excel. Excel VBA: Track If a Cell Value Changes ...

0
Excel VBA: Read Cell Value into Variable (3 Suitable Methods)
-1

In this article, I’ll show you how to read a cell value into a variable using VBA in Excel. Download Practice Workbook Download this practice workbook ...

0
Excel VBA: Turn Off Auto Calculate
-1

In this article, I’ll show you how you can turn off auto calculate using VBA in Excel. Excel VBA: Turn Off Auto Calculate (Quick View) Sub ...

0
Excel VBA: Create a Progress Bar While Macro Is Running
-1

In this article, I’ll show you how you can create a progress bar to check the progress of your Macro while it’s running using VBA in Excel. Download ...

0
[Solved]: User Defined Type Not Defined in Excel VBA (2 Quick Solutions)
-1

One of the most common errors that we face while working with VBA in Excel is that the user-defined type is not defined. In this article, I’ll show you why ...

0
How to Use Macro to Clean Up Data in Excel (4 Easy Methods)
-1

In this article, I’ll show you how can develop a Macro to clean data from a data set using VBA in Excel. Download Practice workbook Download this ...

0
Excel VBA: Copy Cell Value and Paste to Another Cell
-1

In this article, I’ll show you how you can copy the value of a cell and paste it to another cell using VBA in Excel. You’ll learn to copy the value of both a ...

0
Excel VBA: Copy Range to Another Workbook
-1

One of the most widely used tasks that we encounter while working in Excel VBA is to copy a data range from one workbook to another. In this article, I’ll show ...

0
Excel VBA: Close Workbook Without Saving
-1

In this article, I’ll show you how you can use Excel VBA to close a workbook without saving. Excel VBA: Close Workbook Without Saving (Quick View) Sub ...

0
Excel VBA: Filter Date Range Based on Cell Value (Macro and UserForm)
-1

In this article, I’ll show you how you can filter a date range from a given data set based on a cell value using VBA in Excel. Excel VBA: Filter Date ...

Browsing All Comments By: Rifat Hassan
  1. 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.

  2. 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/.

  3. 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.

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

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

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

  7. 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.

  8. 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.

  9. 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

  10. 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.

  11. 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?

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo