Hi,
I am writting small macros to be linked at shortcuts to automate routines.
One on them is "Paste Exact Formula".
I would like to be able to paste to a range exact formula I select in another range - Basically replicate the "Paste Formulas" feature that already exist by "Paste EXACT formula"
Here is what I have soe far. I did not manage to by pass a msgbox. I guess the solution is to loop through the active selection in the clipboard.
Can somebody help?
----
Sub CutPasteExactFormula()
' Macro5 Macro
' Macro recorded 5/21/2003 by Simon Lauzier
'
' Keyboard Shortcut: Ctrl+Shift+E
Set mycell = Application.InputBox(prompt:="Select Cell", Type:=8)
myrange = mycell.FormulaLocal
Selection = myrange
End Sub---
I am writting small macros to be linked at shortcuts to automate routines.
One on them is "Paste Exact Formula".
I would like to be able to paste to a range exact formula I select in another range - Basically replicate the "Paste Formulas" feature that already exist by "Paste EXACT formula"
Here is what I have soe far. I did not manage to by pass a msgbox. I guess the solution is to loop through the active selection in the clipboard.
Can somebody help?
----
Sub CutPasteExactFormula()
' Macro5 Macro
' Macro recorded 5/21/2003 by Simon Lauzier
'
' Keyboard Shortcut: Ctrl+Shift+E
Set mycell = Application.InputBox(prompt:="Select Cell", Type:=8)
myrange = mycell.FormulaLocal
Selection = myrange
End Sub---