Thread
:
Changing cell formulas with a macro or VBA
View Single Post
#
2
Posted to microsoft.public.excel.programming
J.E. McGimpsey
external usenet poster
Posts: 493
Changing cell formulas with a macro or VBA
See this message I just posted (Subject: @ Round Formulas)
In article ,
(JDeBeer) wrote:
Have a co-worker that wants to change the formulas in his spreadsheet
to add "=round(" to the front and ",0" to the end. Formulas may be
long or short and there are plenty of them.
He would like a simple macro so he could activate a cell, and hit the
shortcut keys, and make the conversion.
Thanks for any help.
Reply With Quote
J.E. McGimpsey
View Public Profile
Find all posts by J.E. McGimpsey