Im still learning syntax, Just want to know how to set an array.

[Grefcon901]

Trying to only run this sub for these specific sheets because the code originally ran through all sheets. This would be fine however some of the sheets that are not affected do not hold the string " Current" and I believe it causes the run time error Im getting. Instead I am going to run through just the specific sheets listed in the set. My problem is I am still learning syntax and have kinda just vomited out what i thought would work. Thank you for your help.

Please Login or Register  to view this content.

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[Grefcon901]

Thank You so much!! That was all I needed fixed!? Haha Thank you @ TMS!

[TMS]

You're welcome. Thanks for the rep.