Thread: TABLE filter net zero amounts
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
  
Posts: 9,101
Default TABLE filter net zero amounts
Columns("F").AutoFilter _
field:=1, _
Criteria1:=0
Rows.SpecialCells(xlCellTypeVisible).EntireRow.Del ete


"Sinner" wrote:

Hi,

I want to remove all zero balance in the file.
File: http://savefile.com/files/1618048


Thx.

Reply With QuoteReply With Quote