Re: $$Excel-Macros$$- Query

2014-03-09 Thread Atul Kesaria
Hi Team, Thanks for the help. However just found one bug in macro. If the status is N in the AE column then the macro stops at that row and does not processed over to the next row even if the status is Y. Please help in solving that. Regards Atul On Mon, Feb 17, 2014 at 3:53 PM, mrExcel4u

Re: $$Excel-Macros$$ Excel Forum available @ discussexcel.com

2014-03-09 Thread ashish koul
which row you want to pick how r u going to decide that On Sun, Mar 9, 2014 at 1:26 PM, Leo Ruphen logaroo...@gmail.com wrote: Hi Ashish, Thanks for the prompt reply, But i have few columns to be copied to the invoice. Please refer attachment for more details Thanks and Regards Leo On

Re: $$Excel-Macros$$ Excel Forum available @ discussexcel.com

2014-03-09 Thread koul . ashish
Can u share how output will look like Sent on my BlackBerry(R) from Vodafone -Original Message- From: ashish koul koul.ash...@gmail.com Date: Sun, 9 Mar 2014 22:42:50 To: excel-macrosexcel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel Forum available @ discussexcel.com

$$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 there can be 1 or

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

2014-03-09 Thread mrExcel4u
Plz share your workbook Thanks regards, www.MrExcel4U.com http://mrexcel4u.blogspot.com/ On Mon, Mar 10, 2014 at 2:46 AM, Rahman Khan rahmandk...@gmail.com 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

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 mr.exce...@gmail.com wrote: Plz share your workbook Thanks regards, www.MrExcel4U.com