View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sverre sverre is offline
external usenet poster
 
Posts: 78
Default stop loop if prev sheet does not exist

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