Answer the question
In order to leave comments, you need to log in
Answer the question
In order to leave comments, you need to log in
Works. Dim j As Integer
Sub ololo()
Sheets("List").Select
Dim j As Integer
j = 1
Do Until Range("A" & j) = ""
Range("B" & j) = CDate(Range("A" & j)) + 14
Range("C" & j) = CDate(Range("A" & j)) + 21
j = j + 1
Loop
End Sub
Sub ololo()
On Error GoTo WTF
Sheets("List").Select
Dim j As Integer
j = 1
Do Until Range("A" & j) = ""
Range("B" & j) = CDate(Range("A" & j)) + 14
Range("C" & j) = CDate(Range("A" & j)) + 21
j = j + 1
Loop
MsgBox ("No errors! Success!")
GoTo StopThisShit:
WTF:
MsgBox ("ololo!!! Error there: " & Str(j))
Range("B" & j) = "ololo"
Range("C" & j) = "ololo"
Resume Next
StopThisShit:
End Sub
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question