Formatting sheets with macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Someone supplied me with a great addition to a macro, it took a list of different part numbers and created seperate additional sheets with compiled information. As I go back in to the macro for additional tweeking I'm trying to hi-light all of the new sheets via formula/macro in order to format everything. My issue is: at times there could be 3 part numbers or 50 part numbers, i.e. 3 or 50 new sheets, all which need to be formatted. Is there a way to inform the macro to highlight or apply this to all of the additional sheets?
 
Hi
as you didn't provide your existing macro just as a
general idea: You can loop through your worksheets. e.g.

Dim kws as worksheet
for each wks in activeworkbook.worksheets
'do your formating
next
-----Original Message-----
Someone supplied me with a great addition to a macro, it
Click to expand...
took a list of different part numbers and created seperate
additional sheets with compiled information. As I go back
in to the macro for additional tweeking I'm trying to hi-
light all of the new sheets via formula/macro in order to
format everything. My issue is: at times there could be 3
part numbers or 50 part numbers, i.e. 3 or 50 new
sheets, all which need to be formatted. Is there a way to
inform the macro to highlight or apply this to all of the
additional sheets?
 
Back
Top