Re: $$Excel-Macros$$ vlookup help.

2013-11-23 Thread ashish koul
share some sample workbooks On Sun, Nov 24, 2013 at 1:06 PM, Prabhu Pinky wrote: > saved in different workbook and in different location. can you help with > any example sheets. > > > Thanks & Regards, > Prabhu R > > > On 24 November 2013 12:35, ashish koul wrote: > >> saved in different workbo

Re: $$Excel-Macros$$ vlookup help.

2013-11-23 Thread Prabhu Pinky
saved in different workbook and in different location. can you help with any example sheets. Thanks & Regards, Prabhu R On 24 November 2013 12:35, ashish koul wrote: > saved in different workbook or in same workbook > > you can use application.worksheetfunction.vlookup > > MsgBox Application.

Re: $$Excel-Macros$$ vlookup help.

2013-11-23 Thread ashish koul
saved in different workbook or in same workbook you can use application.worksheetfunction.vlookup MsgBox Application.WorksheetFunction.VLookup("4AC", Sheets(2).Range("A:B"), 2, 0) On Sun, Nov 24, 2013 at 11:32 AM, Prabhu Pinky wrote: > Hi Experts, > > How to do vlookup in VBA. i have two she

$$Excel-Macros$$ vlookup help.

2013-11-23 Thread Prabhu Pinky
Hi Experts, How to do vlookup in VBA. i have two sheets saved in different locations. i need to do vlookup in sheet1 by referring another sheet saved in different location. please help. Thanks & Regards, Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ VBA basic concept

2013-11-23 Thread Prabhu Pinky
Hi Dharm, You can refer the belwo website to learn VBA basic. its so simple and understandable. http://www.excel-pratique.com Thanks & Regards, Prabhu R On 24 November 2013 10:12, Dharm Pd wrote: > > > Dear All, > > I work in Excel from last 8 years and understand almost all function of >

$$Excel-Macros$$ VBA basic concept

2013-11-23 Thread Dharm Pd
Dear All, I work in Excel from last 8 years and understand almost all function of Excel but nothing about VBA. Kindly share VBA basic concept or any help file regarding VBA. Thanks in advance -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) !

$$Excel-Macros$$ Re: ExcelAutomate.blogspot.in

2013-11-23 Thread anoop kumar
Introduction to VBA programming...guys please check it out http://excelautomate.blogspot.in/2013/11/what-is-vba-writing-your-first-vba.html On Wednesday, 20 November 2013 14:54:56 UTC+5:30, anoop kumar wrote: > > Hi webies, > > I just started blogging, please check the excel automation blog >

Re: $$Excel-Macros$$ Stuck in attaching multiple image files in email body

2013-11-23 Thread Farrukh Shaikh
yup On Fri, Nov 22, 2013 at 7:10 PM, ashish koul wrote: > is it working now > > > On Tue, Nov 19, 2013 at 3:46 PM, Farrukh Shaikh wrote: > >> i have done that also .! & some of the images are attached as an >> attachment and against them there is a red cross in the email body, and >> some imag