Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro recording
Is there a way of recording a macro that will perform the
keystrokes that we do - including editing of cells by using the "F2" function key. I am wanting to write a procedure that will edit the formulae in cells in a workbook ie I want the macro to go into the cell in a sheet that have formulae in them like ='Sheet1'!A10/'Sheet1'!C10 (say in E10) and replace with =if(Iserr('Sheet1'!A10/'Sheet1'!C10),0,'Sheet1'! A10/'Sheet1'!C10). When trying to do this by recording, the recording seems to switch off when I go into edit mode. This would be Ok if I wanted relative copies I can record in "relative mode", but the formulae I want to edit refer to different sheets rather than relative references on the same sheet. Any ideas would be welcome. TIA Ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recording Macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Recording Macro | Excel Worksheet Functions | |||
Recording a macro ... | Excel Discussion (Misc queries) |