Search : in
By :

Macro to read a Excel formula

Suvarna, on Jul 1, 2009 4:24:39 am BST 
 Report this message to moderators

Hello,

I have to wite a macro to read the excel formula and find if the cell is blank then display "-" but the formula should be present in the excel only cell data should change.Whenever i execute the work book the cells should be refreshed.

Kindly provide me the inputs.

Thanks,
Suvarna

Configuration: Windows 2003 Internet Explorer 6.0

Best answers for « Macro to read a Excel formula » in :
Excel – Formula for cell calculation Show Excel – Formula for cell calculation Issue Solution Note Issue Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get the calculation to utilize J3 if...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
[Excel]changing cell formula to text Show[Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
[Excel] – Running Macro Automatically Show[Excel] – Running Macro Automatically Issue Solution Issue I have a macro in excel which needs to be run twice a day and I don’t even want to open the excel sheet. How can I make this process automatic? If I can convert the macro...