-
Solved: Syntax question: Range(....)
In the first two lines of code, this is confusing me why the first one is accepted/valid by the compiler rather than the second one.
The third "&" is required to create the proper range stmt. for the compiler, why?
[VBA]
Range("J" & i & ":O" & i).Delete shift:=xlShiftUp
Range("J" & i ":O" & i).Delete shift:=xlShiftUp
[/VBA]
[VBA]
For i = lrwSource To 3 Step -1
If Cells(i, "O").Value = "x" Then
Range("J" & i & ":O" & i).Delete shift:=xlShiftUp
End If
Next i
[/VBA]
my site: www.ecboardco.com
was built w/ a majority of the assistance from the board members here... thanks VBAX.
Just because I see something, doesn't mean that what's actually happening is what I see.
You don't get from 0-90 by standing still!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules