declaring an array (i think)

[Cindy]

I am really new to this, so any help will be appreciated.

I am trying to copy a group of cells. I figured out how
to copy a range that does not change but I need to know
how to copy one that changes based on the data that is in
the worksheet. I created a cell, say a1, that will
change from say a2:j7 to a2:j8 depending on what the user
inputs.

Is there a way to select the group of cells based on what
is in cell a1?

Thanks for your help.

 

[Frank Kabel]

Hi Cindy
not quite sure but try
sub foo()
dim rng as range
set rng = range(range("A1").value)
rng.copy
.....
end sub

 

[Guest]

Frank, Thank you so much that worked perfectly.

-----Original Message-----
Hi Cindy
not quite sure but try
sub foo()
dim rng as range
set rng = range(range("A1").value)
rng.copy
.....
end sub

--
Regards
Frank Kabel
Frankfurt, Germany

.