Quick question about With, formatting and macro recording

[Luke777]

Hi all,

I've just recorded a macro on a fresh wb with only one sheet - its a long list of formatting things like fill colours, column widths, font size/colour.

I've noticed, however, that in the macro no sheet reference is recorded, only ranges, because there is only a single sheet. If I wish to specify that this macro should run on a specific sheet or bring it over to another wb at some point in the future, would i be best to sandwich the entire recorded marco with "With Worksheets("name") bla bla bla End With"?

Also I know recording macros this way ends up generating a much longer macro than strictly necessary but I'm not spending too much time faffing about with formatting shenanigans

Thanks all!

 

[Joe4]

That is one way.

Or, you could just select/activate the sheet you want to run it against at the beginning of the code, as without any sheet references, it defaults to run against whatever the active sheet is at the time.