Public Variable dilemma

  • Thread starter Thread starter Brettjg
  • Start date Start date
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.
 
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
 
Back
Top