Thread: Error with a Macro
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Sondra Powers Sondra Powers is offline
external usenet poster
  
Posts: 1
Default Error with a Macro
Tom:

Tried it and it didn't work
Range("A1:AN1").CurrentRegion.Select
Selection.AutoFilter

Selection.AutoFilter Field:=40, Criteria1:="x" (THIS ROW ERRORING)

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Selection.AutoFilter

Any help would be appreciated.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply With QuoteReply With Quote