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

microsoft-excel-courses - excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Excel

microsoft-excel-courses - Excel

ResolvedVersion Standard

Sarah has attended:
Excel Advanced course

Excel

When recording a macro, and you want to insert a row after a set of criteria, but the number of criteria will change each time the macro is run, how do you do this whilst recording?

RE: Excel

Hi Sarah

Thanks for your question.

This would likely require writing a bit of code, since the row will need to be inserted in a slightly different position each time.

Amanda

Excel tip:

Move to edge of data block

When data is held in a block, however large, use the Ctrl key with your cursors to move quickly to the far edge of the block. Works with all 4 direction keys.

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.09 secs.