Need help on moving to next column
I use this line of code to look for the data that I need:
Windows("MAPReport.xls").Activate
Dim LastRowA As Long
With Worksheets("Summary")
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
With .Range("F2:F" & LastRow)
.Formula = "=1+3"
.Value = .Value
End With
End With
But, how do I state that if F2:F is not empty go to the next available
column (in this case column G)?
|