$$Excel-Macros$$ Query for autofit columns.

Quuery for autofit -- 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 @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

$$Excel-Macros$$ multiple files to single file

Sir, i need a macro to import multiple file to single file i got some files in a week later i copy those to 1 file some time not copy (some in 2003 format,some 2007,some .csv,.xlsm etc) some times files contains more than 1 sheet need help copy all those files which i save in Latest Data(this

Re: $$Excel-Macros$$ Query for autofit columns.

Hi Mandeep, Please check the attached file. let me know if I am missing something. Regards Gaurav Devrani On Thu, Mar 12, 2015 at 1:43 PM, Mandeep baluja mandeepbal...@gmail.com wrote: Quuery for autofit -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Query for autofit columns.

Not working Range(C8).CurrentRegion.Columns.AutoFit this line will unhide the hide columns in between the range. i have tried visible columns property but its not working. On Thursday, 12 March 2015 14:37:51 UTC+5:30, Gaurav Devrani wrote: Hi Mandeep, Please check the attached file. let

Re: $$Excel-Macros$$ Please help me Urgent

Dat's Cool Vaibhav. Thanks. On Wed, Mar 11, 2015 at 11:32 PM, Michael Vinoth michaelvino...@gmail.com wrote: Very Nice... Mr.Vabz On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote: Suppose you have value in cell A1 then type follo. formula in A2 dont press enter press F9,

$$Excel-Macros$$ Re: Sum value of closing balance of date

Hi I do not know how to do this with using only one formula. I added column. My method attached. Waiting for somebody who use one formula. Maybe any array formula? Regards W dniu czwartek, 12 marca 2015 11:04:33 UTC+1 użytkownik Ashish_Bhalara napisał: Dear experts, I need function to sum

$$Excel-Macros$$ Re: Sum value of closing balance of date

Hi Ashish, Please find the attached macro file. Regards, MV On Thursday, March 12, 2015 at 3:34:33 PM UTC+5:30, Ashish_Bhalara wrote: Dear experts, I need function to sum only closing value of particular date, pls see attached file for example. Regards. Ashish Bhalara 9624111822

Re: $$Excel-Macros$$ Formula based on some criteria

Hi Rameshwari , Please check the file. Let me know if it does not work for you. Regards Gaurav Devrani On Thu, Mar 12, 2015 at 5:47 PM, Rameshwari rameshwarish...@gmail.com wrote: Hello team, I stuck with one formula, please help me on this. Formula based on some criteria. Sheet

$$Excel-Macros$$ Re: vba recorded macro not working

Hi Mandeep, I would appreciate you looking at the attached worksheet, I have written and explanation in a comment on the worksheet explaining the issues I am experiencing, I thought it would be easier for you to understand. On Sunday, March 8, 2015 at 12:08:13 PM UTC-5, Mike B wrote: Thank

$$Excel-Macros$$ Sum value of closing balance of date

Dear experts, I need function to sum only closing value of particular date, pls see attached file for example. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

$$Excel-Macros$$ Formula based on some criteria

Hello team, I stuck with one formula, please help me on this. Formula based on some criteria. Sheet “Question” having currency name with the prices, based on currency name prices need to update the value in answer filed. Master sheet will be a reference for the currency. Every 13 row

Re: $$Excel-Macros$$ Query for autofit columns.

Okay. .I got it. On Thu, Mar 12, 2015 at 2:41 PM, Mandeep baluja mandeepbal...@gmail.com wrote: Not working Range(C8).CurrentRegion.Columns.AutoFit this line will unhide the hide columns in between the range. i have tried visible columns property but its not working. On Thursday, 12

Re: $$Excel-Macros$$ multiple files to single file

what is the password to view the macro code. Thanks Regards, Prabhu R On 12 March 2015 at 11:43, Mahesh Patil zmpa...@gmail.com wrote: Hi, Collect all excel files under one folder. Use attached file to merge all excel files. Regards, Mahesh Patil On Mar 11, 2015 6:32 PM,