View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
Kieran[_15_] Kieran[_15_] is offline
external usenet poster
 
Posts: 1
Default find & delete + fill to end code?

..find needs to be qualified by a range reference

try

Dim c As Range

With Columns("B")
Do
Set c = .Find("0", LookIn:=xlValues, LookAt:=xlPart, _
MatchCase:=False)
If c Is Nothing Then Exit Do
c.EntireRow.Delete
Loop
End With


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