Range Address Memory Variable Limitation
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
|