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

2012-07-15 Thread kumar.ashish861
Hi All, Iam Ashish from Delhi, I love excel and loves to learn new tweeks and tricks. Thish Forum is ROCKS..! On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote: > > Hey all new and current posters, > > Welcome to excel group,one of the largest online community of exce

$$Excel-Macros$$ Batch process save workbooks from xls to xlsm if macro from xls or xlsx or xlsm to xlsb is size > 8k

2012-07-15 Thread bpascal123
Hi there, I have started this code (more or less following Norrain's code about listing files from a folder...) but I see difficulties to meet all the conditions as stated in the subject working as I want. If someone wants to help with this. I have successfully worked out some code in this work

RE: $$Excel-Macros$$ Failure of code when trying to break a section out into a seperate routine

2012-07-15 Thread Asa Rossoff
Hi Anil, Try using the same data types in the calling routine ( PowerReturnOutput ? ) and the called routine ( EnterPN ). > PNArray() and OutputRng have values in the immediate window. When you say they have values, do you mean they have the expected values? Did you check the elements of the arr

$$Excel-Macros$$ Failure of code when trying to break a section out into a seperate routine

2012-07-15 Thread Anil Pandit
Hi all, I have the following code in a sub routine which works (please see code in bold font), but which I want in a separate routine, so I can re-use the code. -- Sub PowerReturnOutput() ' This sub procedure looks up the part number on she

$$Excel-Macros$$ page number - Reg

2012-07-15 Thread jmothilal
Dear Any one My work sheet1 have 50 Pages. if I fix the page No in column footer page no assign with 1 to 50, but i want start 51 to 100, in ms word page no start with is available but excel i don't know , guide me any one. Thanks with -- *J.Mothilal : **Universal Computer Systems : # 16,

Re: $$Excel-Macros$$ Re: column width - Reg

2012-07-15 Thread jmothilal
Thanks sir it's working macro as my expecting Thanks with Mothilal.J On Thu, Jul 12, 2012 at 10:31 PM, Paul Schreiner wrote: > Are you wanting to do this manually? > or with a macro? > > To do it manually, > 1. Select the sheets you want updated. > 2. Select Sheet1 > 3. Right-click on the first