Thanks Ganesh
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ganesh N
Sent: Wednesday, 5 March 2014 12:27 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Record Macro to Filter out blanks
Hi Elaine,
Replace with Criteria1:="<>"
com [mailto:excel-macros@googlegroups.com]
On Behalf Of RicardoR
Sent: Wednesday, 5 March 2014 9:22 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VBA to change number
Hi elaine chong,
See attached this example
Basole.
2014-03-04 21:32 GMT-03:00 Elaine gm
Dear Ashish
It works well and produced the 3 PDF files into the folder created. But
there are 2 problems.
1. It will still says macro error and debug will bring me to the
highlighted
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Soa\" &
CL.Value & ".pdf", Qualit
