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 schreiner_p...@att.netwrote: 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.

$$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,

$$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

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

$$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 excel