Public Variable dilemma

[Dave Peterson]

Excel has a collection of sheets--it's all the sheets in the workbook. But
there is no collection of ranges.

Maybe you want something like:
Public Property Get Range(myAddr as string) As Range
Set Range = pTT.Range(myaddr)
End Property

So you can pass it the address of the range you want.

 

[Dave Peterson]

I'm in the midwest.

Chip is a professional developer. If you want to hire him, you should refer to
his web site:
http://www.cpearson.com/excel/consult.aspx

 

[Brett]

I see, but I still can't get it to work, it's just too complex for me. I
won't get anywhere until I get a response from Chip, so I'll leave it alone
for a while. I may have to go back to the pevious method and using you
original idea, because this amount of time trying to figure this out is
crazy. Thanks for your assistance, Brett

 

[Brett]

THIS POST IS NO LONGER NEEDED - I'LL REPOST