RE: $$Excel-Macros$$ Add to an Existing formula in a Cell using VBA

Hi Try this code: Sub AddFormula() Range(A6) = Range(A6).Formula /SUMPRODUCT((C4:C8=B1)*(D4:D8=B2)) End Sub Regards - Dave. Date: Fri, 27 Nov 2009 14:46:15 -0800 Subject: $$Excel-Macros$$ Add to an Existing formula in a Cell using VBA From: stvn.tay...@gmail.com To:

$$Excel-Macros$$ Re: hi sir please help (Getting range reference from user)

Dear Ashish, Below is the modified code. Just a little modification in your existing code and it is working fine. Sub Macro1() i = Application.InputBox(enter range) ' If you want to select A2:B5 then enter as A2:B5 Dim As Range Set = ActiveSheet.Range(i) Sheet1.Activate

Re: $$Excel-Macros$$ Replace contents in a formula used for whole sheet.

Dear Deshpande, I think a smart use of Ctrl + H (Find Replace) will do the task here. Try identifying unique item to be replaced in entire worksheet(s) and just go ahead. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com

Re: $$Excel-Macros$$ Copy the formula till end of data without using copy paste every time we add the add to the sheet

Dear Ramesh, After typing in the formula, watch the bottom right side of the cell for a small + sign and just double click on it and your are done. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062

$$Excel-Macros$$ Help required in repeating calculation using macro

Hi ALL, Please help me in the repeating some calculations by using the macro. the following are the details for that we have to do calculation on the Employee Summary Rep tab. Please look into A17 row i.e., the subtotal for Organisation name ABC now what we have to do is to calculate the sum of

$$Excel-Macros$$ ADO

Hi Please tell me the difference between ADODC and ADODB and how to move to next record using ADODC. I didnt see any method like Adodc1.MoveNext Hemant Hegde -- -- Some important links for excel users: 1. Excel

$$Excel-Macros$$ when workbook open ask passward

Dear Excel Guru's, Please help me I want to create macro for workbook which using for showing different persons different sales report..but I want to use different passward for different person For e.g (for mr raju - passward may be Raju , Mr Sankay - Passward may be Sanjay etc.) If we

Re: $$Excel-Macros$$ Pls provide me code here.

Hey Ashish, Brilliant work. keep it up ... Thanks a lot Hems On Sat, Nov 28, 2009 at 1:16 AM, ashish koul koul.ash...@gmail.com wrote: sorry forwarded you the wrong attachment earlier On Sat, Nov 28, 2009 at 12:16 AM, ashish koul koul.ash...@gmail.comwrote: hi check the attachment

$$Excel-Macros$$ Re: when workbook open ask passward

Hi Umesh, Just answerd this one. Let me know if you do not find the respective email. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 11/28/09, Umesh Matkar matkarum...@gmail.com wrote: