General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel VBA - Scan Column Range
I need to amend the range of columns. Instead of going from G to L, I need it to go from G to J, and include L. That means Column K is omited. Here is the code:
For i = 103 To 108 'Column G to L 103-108
Worksheets("SGAUST").Activate
If Len(Range(Chr(i) & intActiveRow).Value) < 2 Then
Else
intSeq = intSeq + 1
strETA = Convert_Date(CDate(Range(Chr(i) & intActiveRow).Value))
strPort = Convert_Port(CStr(Range(Chr(i) & PORTROW).Value))
What should I do? I tried to change to:
For i = 103 To 106 & 108
But I had an error on the Len line. Pls advise.
Thanks in advance.