G
Guest
Hi,
How do I stop following loop if prev sheet does not exist? It should still
make
Application.DisplayAlerts = true
??
T
----------------------
Application.DisplayAlerts = False
x = 6
Do While Cells(x, 2).Value <> ""
Sheets("makron").Activate
ActiveSheet.Previous.Select
ActiveSheet.Delete
x = x + 1
Loop
How do I stop following loop if prev sheet does not exist? It should still
make
Application.DisplayAlerts = true
??
T
----------------------
Application.DisplayAlerts = False
x = 6
Do While Cells(x, 2).Value <> ""
Sheets("makron").Activate
ActiveSheet.Previous.Select
ActiveSheet.Delete
x = x + 1
Loop