Hi Dave,
I got it now... Any way i need to put in a code for dynamically changing the range and can do it Thanks a lot Regards Habeeb From: davebonall...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: formula in macros Date: Fri, 15 May 2009 17:01:37 +0800 Hi Habeeb, Have a look at the attached, and see if it does what you need. Regards - Dave. From: habeebc...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ formula in macros Date: Fri, 15 May 2009 04:34:26 +0000 Hi Guys, I currently written a code were in total will be populated by adding various sub totals. But I am not able to put in the formula for adding for future reference. I am not able to think a logic for that. I have explained my requirement in the attachement. Please help me Thank you Habeeb MSN Battles We pitch one stalwart against the other and give you the power. Who will you vote for? Share photos while you chat with Windows Live Messenger. Let ninemsn property help Looking to move somewhere new this winter? _________________________________________________________________ Drag n’ drop—Get easy photo sharing with Windows Live™ Photos. http://www.microsoft.com/india/windows/windowslive/photos.aspx --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
