excel vba courses london - Macros

Resolved · Low Priority · Version Standard

Thu 1 Mar 2007, 09:58 Delegate Laurence said...

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

Fri 9 Mar 2007, 16:03 Trainer Carlos said...

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:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function

View all Excel hints and tips

excel vba courses london - Macros

Macros

RE: macros

Excel articles

Excel tip:

Display Functions on Worksheets