itil

ITIL Reporting

excel

ITIL 4

excel

Power BI

excel

Excel Formula | Macro | Script

Skip empty cells using a macro in an excel report

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.

macro excel

 

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/are the macro(s) ?

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

Interesting Topics