Tom - Thank you for your help. I appreciate it.

Thx
MSweetG222



"Tom Ogilvy" wrote:

rng.select

would again select them

--
Regards,
Tom Ogilvy


"MSweetG222" wrote in message
...
Tom - Thank you for your response and correction of my issue.

Once I store a reference to the cells as you indicate below, what code is
needed to "select" those same lines? Or are you saying that I cannot
select
ranges in excess of the 255 character limitation?


Thx
MSweetG222



"Tom Ogilvy" wrote:

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