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