View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MSweetG222 MSweetG222 is offline
external usenet poster
 
Posts: 158
Default 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