Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel vba courses london - macros

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses london - Macros

excel vba courses london - Macros

ResolvedVersion Standard

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

Excel tip:

Quickly select a block of data

To quickly select a block of data make sure your active cell is somewhere whithin the block of data and then press Ctrl+* or Ctrl+Shift+8.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.