Running Same macro on Multiple sheets

**shilpigupta79** · 06-27-2013, 08:50 PM

Hi,

I am new to VBA and have gone through all the codes for my problem but none of it is working.

This is the code I want to run on Multiple sheets-
----------------------------------------------

Please Login or Register  to view this content.

------------------------------------

This is the code with which I am trying to make it work on multiple sheets
---------------------------------------------

Please Login or Register  to view this content.

-----------------------------------

This gives a compile error "Next without For". Please help.

Thanks
~S

**wenqq3** · 06-27-2013, 09:55 PM

Hi shilpigupta79, welcome to Forum.
Please use forum tool to code tags your code so is readable. Thanks

Forum Rule#3,
3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

**AB33** · 06-28-2013, 03:18 AM

Untested. Personally, I tried to avoid until loop and would prefer to loop using for next. If you are trying to loop through range A, I would change the code like this.

Please Login or Register  to view this content.

**shilpigupta79** · 07-01-2013, 02:46 AM

Thanks!!
However, both the codes don't do anything at all.
The code below works only on one sheet.

Please Login or Register  to view this content.

Any help to make this run on multiple worksheets would be greatly appreciated.

Thanks
~S

**AB33** · 07-01-2013, 03:29 AM

However, both the codes don't do anything at all?
It is your code and do not know what do you expect them to do. I have only adjusted the code.
Your latest code loops through all sheets.