Getting a macro to run a formula in a cell?

  • Thread starter Thread starter Juan
  • Start date Start date
J

Juan

I know this is simple but... how can I get my on-screen button which ha
a macro assigned to it, to put a formula in a cell. .

In other words, I made a "Reset" button that sets many cells to "0"
others to certain numbers (like 450 or 50) and two others need to hav
a formula. When I set the code in the macro to:

Range("B53").Select
ActiveCell.FormulaR1C1 = "b3*.0035"

It puts the above formula in the cell instead of computing the answer.
All help is appreciated. Please help oh mighty Excell Gods
 
Juan, try this

Range("B53").Select
ActiveCell.Formula = "=b3*.0035"

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Thanks Paul! I knew that it would be something simple. I had not pur
in the second "=" sign. Duh! Thanks again.
 
Back
Top