Please help me with the following:
I need to select a range of information, for example
Sheet1.Range("A17:K17")
but due to variable incoming information i need to cupple the range to
a variable so that a variable range get selected
example: Dim z as integer
z = 10
sheet1.range("A" & Z).select
I know that A10 will be
selected
but Sheet1.Range("A17:K17") ?????????
--
T.c.Goosen1977
------------------------------------------------------------------------
T.c.Goosen1977's Profile:
http://www.excelforum.com/member.php...o&userid=35895
View this thread:
http://www.excelforum.com/showthread...hreadid=556833