View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mmarek mmarek is offline
external usenet poster
 
Posts: 1
Default Formula Editing Macro

Can anyone help with a macro that will edit a formula (i.e. add to th
end of a formula) and then move down a row and edit that formula in th
same way?

My macro (from simply recording keystrokes) replaces the formula in th
second row with the new formula in the first row, but I need to retai
the original formula in the second row, just adding to the end of it.

This is easy to do in Lotus 123 with the {edit} command, but ther
doesn't seem to be a corresponding VBA command.

Thanks for any help anyone can offer

--
Message posted from http://www.ExcelForum.com