Thread: macro to conditionally delete 3-row blocks in excel
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
  
Posts: 5,302
Default macro to conditionally delete 3-row blocks in excel
Hi Marty,

Set SH = WB.Sheets("Sheet1") b '<<=== CHANGE

should read:

Set SH = WB.Sheets("Sheet1") '<<=== CHANGE



---
Regards,
Norman


Reply With QuoteReply With Quote