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 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 @ > https://www.facebook.com/discussexcel > > F

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 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 March 2015 14:37:51 U

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.

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 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) ! Jo