Limiting a Macro applied to only 1 worksheet in a file

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

That worked great! but it seems to be a lot slower now, when it hides the identified columns it's now has a lot of blank columns on the right all the way to "XFD". Is there a way to limit the range and say only apply to columns A:RA?

Hi again,

As always, it's much easier for us to understand your requirements if you include a sample workbook and code - the code you posted has nothing to do with hiding columns.

As posted, your original code should take longer to execute as it operates on every worksheet rather than on just one specific worksheet.

If you give us some idea of the code you're using to hide columns we may be able to suggest something to speed up the process.

Regards,

Greg M