# Rifat Hassan

Rifat Hassan, BSc, Electrical and Electronic Engineering, Bangladesh University of Engineering and Technology, has worked with the ExcelDemy project for almost 2 years. Within these 2 years, he has written over 250 articles. He has also conducted a few Boot Camp sessions on effective coding, especially Visual Basic for Applications (VBA). Currently, he is working as a Software Developer to develop and deploy additional add-ins to enhance the customers with a more sophisticated experience with Microsoft Office Suits, especially Excel.

## Designation

Software Developer in SOFTEKO.

## Education

B.sc in Electrical and Electronic Engineering (EEE), Bangladesh University of Engineering and Technology (BUET).

## Expertise

Data Analysis, Content Writing, C, C++, Java, Python, JavaScript (Basic), VBA, vb.net, Microsoft Office.

## Experience

• Software Development
• Technical Content Writing

## Summary

• Currently working as Software Developer in SOFTEKO
• Started technical content writing of Excel & VBA in June 2021 later promoted to Software Developer.
• Accomplished Undergraduate thesis on Computer Simulation and Study of Real FineScenarios of Optical Fiber Using COMSOL MULTIPHYSICS.
• Participated in Multiple Solo and Team Projects as a Part of Undergraduate Course Works, like Developing a Sensor Based Monitoring System for Disabled Persons, Developing a Booth Multiplier using Very Large Scale Integration (VLSI), etc.

## Excel VBA: If Statement Based on Cell Value: 2 Practical Methods

Method 1 - If Statement Based on Cell Value of a Single Cell in Excel VBA Weâ€™ll learn to use an If statement based on the value of a single cell. Letâ€™s try ...

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

In this article, Iâ€™ll show you how you can create a dynamic chart in Excel using VBA. Watch Video â€“ Create a Dynamic Chart in Excel Using VBA ...

## Excel VBA: Set Variable to a Cell Value (3 Practical Examples)

We will use the sample dataset below to show how to set variables to cell values using VBA. Example 1 - Set Variable to a Single Cell Value Using ...

## Excel VBA: Open Source QR Code Generator

Here's a quick preview of an open-source QR code generator. Excel VBA: Open Source QR Code Generator (Quick View) Function Generate_QR(QR_Value As ...

## Excel VBA: Create a Progress Bar While Macro Is Running

Step 1 - Open the Visual Basic Window Press Alt + F11Â to open the Visual Basic window. Step 2 - Insert a New UserForm Go to the Insert, ...

## [Solved]: User Defined Type Not Defined in Excel VBA: 2 Quick Methods

Method 1 - Spelling Error While Declaring Variables Look at the following lines of codes. Sub User_Defined_Type_not_Defined() Dim Name As Strng Name = ...

## How to Use Macro to Clean Up Data in Excel (4 Methods)

Below is a dataset in the range B2:B12 of a worksheet called Sheet1 that contains some school students' Student IDs, Student Names, Marks, and ...

## Excel VBA: Copy Cell Value and Paste to Another Cell

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

## An Overview to Copy a Range to Another Workbook Using Excel VBA : 8 Step-by-Step Analysis

â§ª Method 1 - Taking the Necessary Inputs Take the necessary inputs to the code. The inputs include The name of the source workbook (Workbook1 in this ...

## Excel VBA: Close Workbook Without Saving

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

## How to Filter a Date Range Based on a Cell Value Using VBA (2 Methods)

An Overview of the VBA Code to Filter Date Range Based on Cell Value in Excel We have a dataset in the range B3:D12 containing Delivery Dates, Delivery ...

## Excel VBA: Insert Timestamp When a Macro Is Run

In this article, Iâ€™ll show you how you can keep a timestamp in Excel VBA every time a Macro is run. Excel VBA: Insert Timestamp When a Macro Is Run ...

## Excel VBA: Convert Formula to Value Automatically (2 Easy Methods)

In this article, Iâ€™ll show you how you can convert a formula of a worksheet to its value automatically using Excel VBA. Excel VBA: Convert Formula to ...

## Excel VBA: Wait Until a Process Completes

VBA provides us with a built-in method called Wait. Weâ€™ll use this method to wait until the process completes. The problem is the method Wait takes a fixed ...

## How to Edit a Macro Button in Excel (5 Easy Methods)

Method 1 - Edit the Display Text of a Macro Button in Excel Steps: We have to create a macro button in Excel. We named it "Run the Macro". The ...

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,

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:

Dim ws As Worksheet
Set ws = ActiveSheet

Dim tbl As ListObject
Set tbl = ws.ListObjects(“Table1”)

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