Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Theuns
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|