$$Excel-Macros$$ Is there any way to find out how much memory is being used by a excel sheet in particular excel file

2012-07-03 Thread LAKSHMAN PRASAD
  Dear Expert, Is there any way to find out how much memory is being used by a excel sheet in particular excel file . Like I have a file named XYZ (5mb memory used ) and in this file have three sheet (sheet1, sheet2, sheet3) then how much memory used by sheets , sheet1-??? sheet2-???

$$Excel-Macros$$ CTRL+D macro

2012-07-03 Thread Amit Gandhi
Hi Experts I want to copy formula of cell D6 to D7 to D8 upto D20 using macro in attached file. Pls help me providing this macro code. Regards Amit -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ Is there any way to find out how much memory is being used by a excel sheet in particular excel file

2012-07-03 Thread Divaker Pandey
:) As your question as my answer. Ek Bucket thi usme pani, patthar , aur lakdi ka tukda tha, uska weight 10 kg tha. ab Shanta ne poocha Pani,pathar aur lakdi ka weight kitna hai, to banta bola pehale pathar nikal do fir weight karo, ab jitna weight kam hoga wo pathar ka weight hoga. aur same

Re: $$Excel-Macros$$ What do you recommend?? If Formulas, Tables with macros, vlookups?

2012-07-03 Thread Jorge Marques
Hi Asa thank you very much for your help, let me see if i can explain better, I answered below the questions in yellow :) 2012/7/2 Asa Rossoff a...@lovetour.info Hi Jorge, I am happy to help you. * the table in the example transporter AA the volumes are the columns 1, 2 to 3, and 4

Re: $$Excel-Macros$$ Is there any way to find out how much memory is being used by a excel sheet in particular excel file

2012-07-03 Thread Deba Ranjan
Well enjoyed the example the story of santa banta. good fun. Thanks Regards, *Deba Ranjan P* On Tue, Jul 3, 2012 at 1:54 PM, Divaker Pandey divake...@gmail.com wrote: :) As your question as my answer. Ek Bucket thi usme pani, patthar , aur lakdi ka tukda tha, uska weight 10 kg

Re: $$Excel-Macros$$ Is there any way to find out how much memory is being used by a excel sheet in particular excel file

2012-07-03 Thread NOORAIN ANSARI
Dear Lakshman, pls see below link.. http://www.excelforum.com/excel-general/501493-sheet-size-in-workbook.html On Tue, Jul 3, 2012 at 1:02 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Dear Expert, Is there any way to find out how much memory is being used by a excel sheet in particular

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

2012-07-03 Thread Bé Trần Văn
Congratulations *Ashish **koul* and *Dilip Pandey*. The help, the second great forum you will make more and better. 2012/7/3 Deba Ranjan drdeva...@gmail.com Dear Ashish and Dilip. Sorry for the delay, its a really awesome stage. heartiest congratulate to both and please keep helping to

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!--Add

2012-07-03 Thread Bé Trần Văn
Congratulations *Ashish koul* and *Dilip Pandey* . 2 you wish to continue to contribute increasingly good forum. 2012/7/3 pankaj gmail account pankaji...@gmail.com Dear Moderator, Please also Ban these kinds of Promotional/Advertisements in this forum. They are not related to Excel Help.

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

2012-07-03 Thread Venkat CV
Congrats..Ashish Dilip *Best Regards,* *Venkat * *Chennai* On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, I am extremely happy to inform you that two members of the group are awarded Microsoft Most Valuable Professional Award. My heartiest

Re: $$Excel-Macros$$ Macro to populate Output file

2012-07-03 Thread ashish koul
Hi its working fine at my place On Tue, Jul 3, 2012 at 1:38 AM, OJEMENI Uzoma uojem...@gmail.com wrote: Ashish, If i were to change the input from numbers too letters as in the *attached file*, what changes to the code would be necessary as i am having an error Run-time error '13' Type

Re: $$Excel-Macros$$ CTRL+D macro

2012-07-03 Thread ashish koul
Sub sample() Sheets(Sheet1).Range(d4:d20).FillDown End Sub On Tue, Jul 3, 2012 at 1:35 PM, Amit Gandhi silkyro...@gmail.com wrote: Hi Experts I want to copy formula of cell D6 to D7 to D8 upto D20 using macro in attached file. Pls help me providing this macro code. Regards Amit --

Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******

2012-07-03 Thread Bé Trần Văn
Show group already have 03 users received decode of the Microsoft, real absolute. I am tham community this because it very useful to add comments expression cho me also like all all user. Sorry, I was busy at the work group, wish all the members of this forum to achieve

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

2012-07-03 Thread Born to Win
Congrats..Ashish Dilip.pls keep helping group Cheer's, Chandrabhan On Tue, Jul 3, 2012 at 6:29 PM, Venkat CV venkat1@gmail.com wrote: Congrats..Ashish Dilip -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

2012-07-03 Thread Excel Vba
Congrats both of them. God bless.. On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, I am extremely happy to inform you that two members of the group are awarded Microsoft Most Valuable Professional Award. My heartiest congratulations to *Ashish koul*

$$Excel-Macros$$ Re: CTRL+D macro

2012-07-03 Thread Prince Dubey
Hi Amit, Please see the attachment. regards Prince Dubey. On Tuesday, 3 July 2012 13:35:23 UTC+5:30, Mitr wrote: Hi Experts I want to copy formula of cell D6 to D7 to D8 upto D20 using macro in attached file. Pls help me providing this macro code. Regards Amit -- FORUM RULES

$$Excel-Macros$$ Re: Is there any way to find out how much memory is being used by a excel sheet in particular excel file

2012-07-03 Thread Prince Dubey
Hi Lakshman, I think you should copy or Move your each sheets into a new work book this help you to know the size of each sheets in your workbook. hope this will help you. regards prince On Tuesday, 3 July 2012 13:02:48 UTC+5:30, lakshm...@yahoo.com wrote: Dear Expert, Is there any

Re: $$Excel-Macros$$ Re: Is there any way to find out how much memory is being used by a excel sheet in particular excel file

2012-07-03 Thread dguillett1
type name of file into a cell and run this macro to determine file size Sub filesize() 'FOR SELECTED MsgBox FILE SIZE IS Format(FileLen(ActiveCell .xls) * 0.0009767, 0) KB End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Prince Dubey Sent:

RE: $$Excel-Macros$$ range formatting

2012-07-03 Thread Asa Rossoff
Hi Pawel, You can accomplish this simply by using conditional formatting. You can either: 1. Use a default format and a conditional format. a. Format D5:J22 with one of the two formats. This would be your default format regarldess on the value in C2. b. Use a conditional

$$Excel-Macros$$ need a macro to change the background color a cell as soon as i change the value (alphanumeric)

2012-07-03 Thread vijay yadav
Hi Members / Experts I need a macro to change the background color of a cell as soon as i change the value (alphanumeric). The background is originally yellow and as soon I change a value it should become no fill (or white ). Sometimes the changed value might be same as previous value ..in

Re: $$Excel-Macros$$ need a macro to change the background color a cell as soon as i change the value (alphanumeric)

2012-07-03 Thread Anil Gawli
Dear Vijay, For this you may use conditional formatting. There is no need to make macro. Thanks Regards, Gawli Anil On Wed, Jul 4, 2012 at 11:00 AM, vijay yadav wrote: Hi Members / Experts I need a macro to change the background color of a cell as soon as i change the value