Macro wont run on all sheets in active workbook

[afpPaul]

I have searched these forums for help on this and tried many of the suggestions given, none of witch has helped. The macro runs on the active sheet but not on all of them. Here is the code Im using.

Please Login or Register  to view this content.

[thisisgerald]

@afpPaul

Please use code tags on your posts. Try this one.

Please Login or Register  to view this content.

Regards,
thisisgerald

[afpPaul]

Thank You For the speedy response, Using your modified code I get a "Create Table" window asking me to select the data for my table.

[JBeaucaire]

Please edit your post #1 and add the code tags as required by the forum rules. No more posts until you edit that post. Thank you for complying.

[afpPaul]

Sorry I am New To Forums. I think I have made the required changes.

[JBeaucaire]

Like so:

Please Login or Register  to view this content.

[afpPaul]

Thank You for the reply. This code works but only on the active sheet. If I click on another sheet and run the macro it works on this sheet only. I need the code once called to run on all the sheets in the workbook.

[thisisgerald]

@afpPaul

Try to replace this code

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

[afpPaul]

Thank You So Much Gerald! You are the best. This works perfect.

[thisisgerald]

@afpPaul

You're welcome! I'm only good. Our moderators are the best.

Warm Regards,
thisisgerald