Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses london - Macros
Resolved · Low Priority · Version Standard
Laurence has attended:
No courses
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
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
|
Excel tip:Display Functions on WorksheetsFunctions in Excel can be difficult to recall their format/syntax |
We'll call during UK business hours
Server loaded in 0.12 secs.