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=556832

Theuns
 

RowNum=10
sheet1.range("A" & RowNum & ":Z" & RowNum).select

--
Jim
"T.c.Goosen1977"
<T.c.Goosen1977.2a5snn_1151576705.7204@excelforu m-nospam.com wrote in
message news:T.c.Goosen1977.2a5snn_1151576705.7204@excelfo rum-nospam.com...
|
| :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=556832
|

Theuns
 

One mo

Dim Z as long
Z = 17
Sheet1.select
sheet1.range("a" & z).resize(1,11).select
'or
sheet1.cells(z,"A").resize(1,11).select

resize(x,y) means to make it x rows deep and y columns wide.

(And sheet1 has to be selected before you can select any range on that sheet.)

"T.c.Goosen1977" wrote:

: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=556832

--

Dave Peterson

Theuns
 

Thanks it works like a bom

regards
Theun

--
T.c.Goosen197
-----------------------------------------------------------------------
T.c.Goosen1977's Profile: http://www.excelforum.com/member.php...fo&userid=3589
View this thread: http://www.excelforum.com/showthread.php?threadid=55683