Thread: Excel VBA syntax problem
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
pikus pikus is offline
external usenet poster
  
Posts: 1
Default Excel VBA syntax problem
Faster still:

Application.ScreenUpdating = False
For counter = 1 To 2000
For x = 1 To 4
Rows(counter).Delete
Next x
Next counter
Application.ScreenUpdating = True

- Piku

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote