Is it possible to Set a range so that I can use it on any worksheet in
my workbook?
Currently, I am selecting each sheet and then setting the range. What
I would like to do is set it once and then be able to call it from any
worksheet.
Here is my range code:
Dim rngsort As Range, rngsubtotal As Range
' I then set these ranges below on each sheet I am working on...
Set rngsort = Range(Cells(4, 1), Cells(Rows.Count, 7).End(xlDown))
Set rngsubtotal = Range(Cells(3, 1), Cells(Rows.Count, 7).End(xlDown))
Thanks for any advice offered!!!
--
Celt
------------------------------------------------------------------------
Celt's Profile:
http://www.excelforum.com/member.php...o&userid=19413
View this thread:
http://www.excelforum.com/showthread...hreadid=551126