Laurence has attended:
No courses
Macros
help with how to move to next column in a worksheet to test the data in that column (e.g. if cell is blank) and then do something to that column, e.g. delete
RE: macros
From the little you have written you will need to do some VBA coding as a recorded Stand Alone macro won't do.
You will need to use Offset and an If loop to check the next column and do something to it