View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Range Address Memory Variable Limitation

rather than store the addresses, store a reference to the cells

Dim rng as Range
set rng = Selection

I think you are having trouble using the addresses - not storing them.
something like

Range(MyRangeAddresses) would be limited to a string of 255 characters I
believe.

--
Regards,
Tom Ogilvy


"MSweetG222" wrote in message
...
I have a large table on a worksheet.
I am autofiltering on 1 of the fields.
I was going to store the range addresses of the visible cells using:

MyRangeAddresses = Selection.Address

But, there appears to be some sort of limitation. It only stores only a
small fraction of the visible cell addresses.

What should the code be to store all of the visible cell addresses?

Thanks in advance for your help.

MSweetG222