What runs faster?

[usgildav]

Have the macro below running on about 10 individual worksheets (in the "View Code" section). Would the workbook run faster if this were applied to a single macro set up to run across those 10 sheets? If so, could you tell me how to set it up? Been using excel for 20 years but macros are brand new to me....copy paste is about the extent of my skill.

Thank you!

Please Login or Register  to view this content.

[Richard Buttrey]

Administrative Note:

Welcome to the forum.

Plesae note we have rule about enclosing code in code tags. This makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2
Since this is your first post I'll add them this time for you. (I see Leith has beaten me to it!. Thanks Leith. More information about these and other tags can be found here

That said I don;t understand what you mean by 'running on individual sheets. Please explain what you are trying tp achieve and upload your workbook.

[usgildav]

Thank you. My apologies.