Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formulas exact without references changing
Trying to come up with a VBA procedure to copy a cell formula exact into the clipboard that I can paste (cntrl+V) in any other desired cells without the references changing. That way, I can assign the keys Shift+Ctrl+E to the procedure for a short cut. I know about the $ but there are too many formulas to edit. I now do it manually as follows: On the desired cell, F2 Ctrl + Shift + Home Ctrl + C Esc Any ideas? mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=482978 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy an exact formula without changing cell reference | Excel Worksheet Functions | |||
Changing References to Formulas | Excel Discussion (Misc queries) | |||
copying formulas and changing cell references | Excel Discussion (Misc queries) | |||
Copy and Replicate exact formulas | Excel Worksheet Functions | |||
Changing Cell References in Formulas | Excel Worksheet Functions |