Re: $$Excel-Macros$$ Re: Display Vlookup dialog box with vba code

2013-10-19 Thread Anil Gawli
Application.SendKeys ("vlookup") Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Fri, Oct 18, 2013 at 4:37 PM, dr wrote: > Would anyone know how to change or control where the vlookup window opens in > code? > > On Tuesday, October 15, 2013 9:52:24 AM

Re: $$Excel-Macros$$ Write formula without using IFS

2013-10-19 Thread Waseem Saifi
Dear Rajan, Are you looking for this type solution. Regards, Waseem Saifi On Thu, Oct 17, 2013 at 3:31 PM, Rajan sharma wrote: > Thanks for your prompt reply, But i was having some condition, that we are > not suppose to use : > > Write Formula without using > > 1. Where ever there is ifs in l

Re: $$Excel-Macros$$ Matching Total of pair

2013-10-19 Thread ashish koul
please share sample file On Thu, Oct 17, 2013 at 4:54 PM, kartikey patel wrote: > Dear Sir, There are a set of debit values and a set ot > credit values in a column. I want a vba code by whcich the debit value plus > a single / multiple credit value is zero that needs to be m

Re: $$Excel-Macros$$ Paste special using skip blank

2013-10-19 Thread Manoj Kumar
Hi Ravi Thanks you so much. i got it. Thanks & Regards Manoj Kumar On Sat, Oct 19, 2013 at 1:09 PM, Ravi Kumar wrote: > Dear friend, > > ** ** > > ** ** > > I had also attached the screen shot of excel shortcut. Please see the > attached file. > > ** ** > > ** ** > > * * > > *Warm Rega

RE: $$Excel-Macros$$ Paste special using skip blank

2013-10-19 Thread Manoj Kumar
Hi Expert I m not asking for any macro coding. I just want to know is there any sort cut in excel. Plz help me on this. Thanks Manoj On Oct 19, 2013 10:16 AM, "Ravi Kumar" wrote: > ** ** > > Here is the solution… > > ** ** > > Sub copypastconstants() > > Range("A1:A8").SpecialCells