macros

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

resolvedResolved · Low Priority · Version 2003

Rebecca has attended:
Excel Advanced course

Macros

When you run a macro, Does 'Rows to repeat at top' work in macros? When i try and apply it to all selected sheets in a workbook it only seems to apply to the first.

RE: Macros

Hi Rebecca,

Thank you for your question.

I have tried to record a macro as well and as far as I am concerned it won't allow you to apply the macro to all the sheets just to the active one.

I am sure it can be done but it may need Visual Basic code.

Regards

Simon


 

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips


Server loaded in 0.07 secs.