Run the macro on all the sheets except active sheet

**theprincesunil** · 07-03-2012, 04:08 PM

Hi,
I am new to Vba. I have written a code which needs to run my macro on all the sheets except active sheet.

It has to do sum on each sheet at o column. I have attched the sheet.

Please Login or Register  to view this content.

Thanks in Advance for your support.

**shg** · 07-03-2012, 04:55 PM

Maybe

Please Login or Register  to view this content.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

**theprincesunil** · 07-04-2012, 09:36 AM

Thank you very much shg. It is working fine. I just would like to know when ever we are using with, Should we use .code like range etc

**shg** · 07-04-2012, 01:51 PM

The With statement establishes a reference, and the dot operator uses the reference. It avoids a lot of duplicated code when several lines refer to the same object, and reduces the opportunities to introduce an error.