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