Theuns
 

:rolleyes: 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

Theuns
 

Sheet1.Range("A" & x & ":K" & x).Select


--
Kaak
------------------------------------------------------------------------
Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513
View this thread: http://www.excelforum.com/showthread...hreadid=556833