View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Radhakrishna k.v.n.r[_2_] Radhakrishna k.v.n.r[_2_] is offline
external usenet poster
 
Posts: 11
Default Formatting of all sheets at a time

Hi all,

I am Radha krishna, I am having a doubt in Excel VBA programming. In our
work we are doing formats such as Merging, row banding, Button creation,
Print area setting, Hidding and deleting of rows and columns etc. At present
we are doing that in a for loop by selecting each sheet at a time and
applying all the formats and selecting the next sheet and do the same things.
My doubt is whether Is there any way to do these common operations for all
sheets at a time or not? If so Please help me.