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

2015-03-17 Thread Vaibhav Joshi
Check this.. Cheers!! 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 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

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

2015-03-12 Thread Mandeep baluja
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,

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

2015-03-12 Thread Gaurav Devrani
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.

2015-03-12 Thread Mandeep baluja
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$$ Query for autofit columns.

2015-03-12 Thread Gaurav Devrani
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