| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select fields names with "dot" | Excel Programming | |||
| using a "variable" in range names | Excel Discussion (Misc queries) | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
| insert/names/apply - how to "select all" ? | Excel Programming | |||
| Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
Hybrid Mode
