microsoft-excel-courses - excel

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

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

microsoft-excel-courses - Excel

resolvedResolved · Low Priority · Version 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

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Jumping Across the Excel Screen

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Alt+PgDn and Alt+PgUp is the equivalent across the spreadsheet.

View all Excel hints and tips


Server loaded in 0.09 secs.