$$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS

2014-10-05 Thread Kumar Kishore
Dear Masters, Please teach the following functions:- 1. VLOOKUP 2. HLOOKUP and 3. MACROS Thank in advance Regards, Kishore -- 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) ! Join official Facebook page of this forum @

$$Excel-Macros$$ Refresh BackgroundQuery:=False doesn't work

2014-10-05 Thread Nur Hossain
Dear all , I was using attached macro since last few months . and I didn’t get any problem . but today while I am going to run this macro it shows error like. Run Time error ‘1004’: If I press debug then it goes to below line .Refresh BackgroundQuery:=False Would you please check the macro as

$$Excel-Macros$$ Re: Introduce Yourself !!

2014-10-05 Thread sanjay kumar
hello, My name is Sanjay and I work at HCL in Noida. I use Excel, VBA and some other tools for daily tasks. Glad to see all the contributors and posts. Let the learning begin. On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote: Hey all new and current posters, Welcome to

Re: $$Excel-Macros$$ Report

2014-10-05 Thread joseph camill
Hi Vaibhav, Can you please explain the last loop in the code For x = 3 … part. On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 30, 2014 at 4:44 AM, joseph camill

Re: $$Excel-Macros$$ Report

2014-10-05 Thread joseph camill
Hi Vaibhav, I think the end loop i.e. For x = 3 … is counting the number of worksheets in the workbook, if it is less than 3 than it proceeds to execute the code. Is there a way to make Sheet Name dynamic in code. Now we are specifying RAW and Final in the code. This works if there are only 2