Re: $$Excel-Macros$$ Save only a few sheets

2014-03-30 Thread ashish koul
do u want to save the worksheets from active workbook only or from multiple workbooks? On Fri, Mar 28, 2014 at 2:22 PM, Ravinder ravindervbacli...@gmail.comwrote: Pls provide attachement *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Stefano

Re: $$Excel-Macros$$ Macro for IF AND condition

2014-03-30 Thread Renata Torquato
Thanks. That's exactly what I tried before but it doesn't work ... =/ Em domingo, 30 de março de 2014 12h29min52s UTC-3, ashish escreveu: Sub test() With Sheets(Sheet1) If .Range(a2).Value VBA.Date And UCase(.Range(a1).Value) = UCase(ON TRACK ) Then

Re: $$Excel-Macros$$ Macro for IF AND condition

2014-03-30 Thread ashish koul
can u share a sample file? On Sun, Mar 30, 2014 at 9:44 PM, Renata Torquato renataatorqu...@gmail.comwrote: Thanks. That's exactly what I tried before but it doesn't work ... =/ Em domingo, 30 de março de 2014 12h29min52s UTC-3, ashish escreveu: Sub test() With Sheets(Sheet1)