Theuns

[T.c.Goosen1977]

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") ?????????

[Kaak]

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