Some things maybe, but maybe not all.

But is there a problem doing it the way that you do?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Radhakrishna k.v.n.r" wrote in
message ...
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.