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

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

Range("C100:D200").Select
Start=100
Stop=200

How do I word this to select C100 thru D200?

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

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

--
Gary''s Student - gsnu2007


"Fan924" wrote:

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

Range("C100:D200").Select
Start=100
Stop=200

How do I word this to select C100 thru D200?

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

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

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

Rick


"Fan924" wrote in message
ups.com...
Excel 97. I want to replace this with a variable names.

Range("C100:D200").Select
Start=100
Stop=200

How do I word this to select C100 thru D200?