Range("C100:D200").Select with variable names

[Fan924]

Excel 97. I want to replace this with a variable names.

Range("C100200").Select
Start=100
Stop=200

How do I word this to select C100 thru D200?

 

[Guest]

Sub stitute()
startt = 100
stopp = 200
Range("C" & startt & "" & stopp).Select
End Sub

 

[Rick Rothstein \(MVP - VB\)]

You can't use Stop for a variable name in VB, so I changed it to Finish...

Start = 100
Finish = 200
Range("C" & Start & "" & Finish).Select

Rick