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!
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!