Is there a way to make a legit global range?
I want to call the same cell range in different worksheets and just have to specify which worksheet to use the range in. I am looping through a range and I need to use it in several worksheets and don't want to create a whole new loop for the second worksheet. Thanks in advance
Sam
Last edited by samshut; 03-23-2007 at 03:40 PM. Reason: Bad Title
Hello Sam,
Place your range loop in a Standard VBA Module. Declare your Sub or Function to take a String argument which will be the Worksheet name.
For Example:
Sincerely,
Please Login or Register to view this content.
Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks