syntax when using variables

[NoWhereMan2012]

I want to select a range of 2 cells when closing form and returning to excel sheet

if you know the range you use

Range("J6:K6").Select

but I don't know what row its going to be so need to use variable b, how do I rewrite this code?

Tried

Range("J" & b:"K" & b).Select

[Thalassa]

Try

Range("J" & b & ":K" & b).Select

[NoWhereMan2012]

Thanks for reply but didn't work, although it didn't give me error so I guess its possible something else is happening before selection or after?

[shg]

Or

    Dim iRow As Long

    iRow = 42
    Rows(iRow).Range("J1:K1").Select

[NoWhereMan2012]

Thanks for the reply

Does iRow have to be Long?
I want to use the same variable that I am using for my text input which is b as Integer.

as b already has the value I need I just altered your code to

Rows(b).Range("J1:K1").Select

but it didn't work.

[shg]

Yes, the variable should be a Long. Row numbers extend beyond the range of Integer.