A macro is treating the below code as: Range("U5:AE54").Select. How to state the two ranges so the code treats them as two separate ranges?
Please Login or Register to view this content.
A macro is treating the below code as: Range("U5:AE54").Select. How to state the two ranges so the code treats them as two separate ranges?
Please Login or Register to view this content.
Last edited by Phil Hageman; 04-03-2015 at 07:27 AM.
Should be
Please Login or Register to view this content.
Use Union()
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks Jindon and Sixthsense - it works as needed. Appreciate your time. r/Phil
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks