View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jimwood jimwood is offline
external usenet poster
 
Posts: 1
Default Macro to edit a formula.

I have an old lotus macro that I would like to reproduce in excel.
Specifically I would like to have a macro open a cell in an edit mode and
have the cell be a formula of =round(/1.08,2) with the cursor sitting
just in front of the division sign so that someone could enter a number and
have it divide by 1.08. I and a coworker have been trying all sorts of
things but none of them are working.
--
Thanks,
Jim