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

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

Sub RanSelect()
Range("C7:D7").Select
End Sub

I do want to make the 7 variabel...
So I only have to enter 7 and it displays me Range("C7:D7")
If entered 25 it gives me range C25:D25

Any help is appreciated

VB Code:

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

this should work.. i didn't test it

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

The :D was my attempt at humor....

Quote:

---

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

The :D was my attempt at humor....

---

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