Hi
i have a range that i want to copy
because the range can change the range value is built using a
concantinate
the cell holding the concantinate reusult is ap113 the result is
S12:S33
How can i use the result of the concantinate to select the range
ie select s12:s33
next week the range would be t12:t33

thanks kevin

sub copyrngbasedoncell()
Range(CStr(Range("ap113"))).Copy
end sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"kevcar40" wrote in message
...
Hi
i have a range that i want to copy
because the range can change the range value is built using a
concantinate
the cell holding the concantinate reusult is ap113 the result is
S12:S33
How can i use the result of the concantinate to select the range
ie select s12:s33
next week the range would be t12:t33

thanks kevin

You could use this:
=OFFSET(INDIRECT($AP$113),ROWS($1:1)-1,)
and copy it down to cover the range extent, ie by 22 cells
The formulated range will return the values of the range specified in AP113
Any good? ring the stars in google
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"kevcar40" wrote in message
...
i have a range that i want to copy
because the range can change the range value is built using a
concantinate
the cell holding the concantinate reusult is ap113 the result is
S12:S33
How can i use the result of the concantinate to select the range
ie select s12:s33
next week the range would be t12:t33

thanks kevin

Hi,

Sub mySelect()
Range([AP113]).Copy
End Sub
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"kevcar40" wrote:

Hi
i have a range that i want to copy
because the range can change the range value is built using a
concantinate
the cell holding the concantinate reusult is ap113 the result is
S12:S33
How can i use the result of the concantinate to select the range
ie select s12:s33
next week the range would be t12:t33

thanks kevin