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
' second option, change xx by your value
If xx <> Empty Then
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 of your code