| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
loop syntax
can someone correct the syntax in the last line below. Thank you
I just want C(24*i+2):C(24*i+25) to be selected. thanx Dim i As Long For i = 1 To 1 Range("C" & 24 * i + 2:"C" & 24 * i + 25).Select |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
loop syntax
nevermind i got it
Range(("C" & 24 * i + 2), ("C" & 24 * i + 25)).Select thanx "Knox" wrote: can someone correct the syntax in the last line below. Thank you I just want C(24*i+2):C(24*i+25) to be selected. thanx Dim i As Long For i = 1 To 1 Range("C" & 24 * i + 2:"C" & 24 * i + 25).Select |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
loop syntax
Maybe:
Range("C" & 24 * i + 2 & ":C" & 24 * i + 25).Select Or Cells(24 * i + 2, "C").Resize(24, 1).Select or Range("C" & 24 * i + 2).Resize(24, 1).Select I like the middle one! Knox wrote: can someone correct the syntax in the last line below. Thank you I just want C(24*i+2):C(24*i+25) to be selected. thanx Dim i As Long For i = 1 To 1 Range("C" & 24 * i + 2:"C" & 24 * i + 25).Select -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Syntax for stopping a Do Loop? | Excel Discussion (Misc queries) | |||
| "Loop until" syntax question | Excel Programming | |||
| Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
| Problem adding charts using Do-Loop Until loop | Excel Programming | |||
| HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming | |||
Hybrid Mode
