If there are at least 1 empty cell in the column, the macro will stop here in spite that after this empty cell, there are data. To avoid this situation, I need to add a small code inside the main macro so it can skip all empty cells amongst the data.
When I use the macro ?
To skip all empty cells of a column so the macro can run until the end.
How to create the macro ?
Read How to create, edit, hide and select a macro in an excel report
How to create the button to associate it with the macro ?
Read How to create a button and associated it to a macro in an excel report
How to use the macro ?
The macro should be put between the code.
How is the macro ?
Copy the code below and paste it into your macro. You will see my comments in green if exist so follow the help to adapt to your need.
' first option, change xx by your value
If xx <> "" Then
End If
' second option, change xx by your value
If xx <> Empty Then
End If
End Sub
For instance:
Sub test()
Beginning of your code
' depending of your code, it can be Trim(i.Value), Cells(i, 1).Value, i.Value, etc.
If Trim(i.Value) <> "" Then
Your action code to do
End If
End of your code
End Sub
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...