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

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

Range Address Memory Variable Limitation
 

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

Range Address Memory Variable Limitation
 

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

Range Address Memory Variable Limitation
 

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