Re: $$Excel-Macros$$ IF statements in VBA

2014-03-09 Thread ashish koul
If sh.Range("G11").Value = "1...@x.xxx" Or sh.Range("G11").Value = "2...@x.xxx" Or sh.Range("G11").Value = "3...@x.xxx" Then MsgBox "a" End If try like ths On Mon, Mar 10, 2014 at 9:55 AM, mrExcel4u wrote: > Plz share your workbook > > Thanks & regards, > > www.MrExcel4U.com

Re: $$Excel-Macros$$ IF statements in VBA

2014-03-09 Thread mrExcel4u
Plz share your workbook Thanks & regards, www.MrExcel4U.com On Mon, Mar 10, 2014 at 2:46 AM, Rahman Khan wrote: > If sh.Range("G11").Value like "x...@x.xxx" or "x...@x.xxx, > x...@x.xxx" or "x...@x.xxx, x...@x.xxx, x...@x.xxx" Then > >

$$Excel-Macros$$ IF statements in VBA

2014-03-09 Thread Rahman Khan
If sh.Range("G11").Value like "x...@x.xxx" or "x...@x.xxx, x...@x.xxx" or "x...@x.xxx, x...@x.xxx, x...@x.xxx" Then TempFileName = TempFilePath & sh.Name & " February 2014 Invoice " _ & ".pdf" The red colored text means the