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
|