copy

[kevcar40]

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

 

[Don Guillett]

sub copyrngbasedoncell()
Range(CStr(Range("ap113"))).Copy
end sub

 

[Max]

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

 

[Shane Devenshire]

Hi,

Sub mySelect()
Range([AP113]).Copy
End Sub