Thread: VBA macro delete row - Help needed
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default VBA macro delete row - Help needed
Hi,

Am Mon, 20 May 2013 11:00:17 +0200 schrieb Claus Busch:

.UsedRange.AutoFilter Field:=1, Criteria1:= _
"<*ThisRow*"

change the line above to:
..UsedRange.AutoFilter Field:=1, Criteria1:= _
"<*keepThisRow*"


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote