$$Excel-Macros$$ How to know VBA Constant number instead of text

2015-07-07 Thread XL Macros
Hi All, I want to know what is the constant number for any given Build-in Constant. For example: For the below mentioned property we can write text "True" OR 1. For few of the parameters I know the numeric number but for some them not. Is their any way to find the constant value number instead of

Re: $$Excel-Macros$$ Re: please help

2015-07-07 Thread Kumar Bhanushali
Dear Apoorve, It works. Thanks.. Regards, Kumar Bhanushali Re: $$Excel-Macros$$ Re: please help Apoorve Kumar to: excel-macros 07-07-15 06:10 PM Sent by: excel-macros@googlegroups.com Cc: kumar.bhanushali From: Apoorve Kumar To: excel-macros@googlegroups.com Cc: ku

Re: $$Excel-Macros$$ Re: please help

2015-07-07 Thread Apoorve Kumar
Please check this file. Regards, Apoorve On Tuesday, July 7, 2015 at 5:05:38 PM UTC+5:30, Kumar Bhanushali wrote: > > *Dear Apoorve,* > > Please refer this sheet again > > > > > > > *Regards, Kumar Bhanushali* > > >*$$Excel-Macros$$ Re: please help* > *Apoorve Kumar * to: excel-

Re: $$Excel-Macros$$ Re: please help

2015-07-07 Thread Kumar Bhanushali
Dear Apoorve, Please refer this sheet again Regards, Kumar Bhanushali $$Excel-Macros$$ Re: please help Apoorve Kumar to: excel-macros 07-07-15 05:03 PM Sent by: excel-macros@googlegroups.com Cc: kumar.bhanushali From: Apoorve Kumar To: excel-macros@googlegroups.com Cc:

$$Excel-Macros$$ Re: please help

2015-07-07 Thread Apoorve Kumar
Hi Bhanushali, Here is your file with formula. On Tuesday, June 30, 2015 at 3:54:17 PM UTC+5:30, Kumar Bhanushali wrote: > > *Dear Sir,* > > Help Needed > > > > > > > *Regards, Kumar Bhanushali* > DISCLAIMER > The information contained in this e-mail including attachment is meant > onl

$$Excel-Macros$$ please suggest

2015-07-07 Thread Kumar Bhanushali
Dear Sir, 1) Is there any way, that if any value is pasted in column, it should be automatically round off to specified value. 2) Is there any way, that if cell having formula is copied and it will paste to another sheet, but it will paste only formula text removing = from it, not value. Regar