Range("C7:D7").Select...make 7 Variabel

[Chrissie]

Hi...
I've a small Excel VBA problem which should be very easy to solve...

Sub RanSelect()
Range("C77").Select
End Sub

I do want to make the 7 variabel...
So I only have to enter 7 and it displays me Range("C77")
If entered 25 it gives me range C2525

Any help is appreciated

[kleinma]

Sub RanSelect()
    dim sRange as string
    sRange = "25"
    Range("C" & sRange & ":D" & sRange).Select
End Sub

this should work.. i didn't test it

[jim mcnamara]

Matt -
click the disable smilies checkbox on the reply screen.

The was my attempt at humor....

[kleinma]

Originally posted by jim mcnamara
Matt -
click the disable smilies checkbox on the reply screen.

The was my attempt at humor....

thanks jim.. after almost 3k posts i never looked at that