Doctor P
05-01-2006, 09:19 PM
I am trying to do what should be very simple.
I am trying to copy a range of cells to the clipboard, then delete the range, run some code to assess the impact this has had on dependent formulas, and the paste back the original text, values, and formulas.
I would expect the simplified code to look something like this.
Sub GOGO()
Selection.Copy
Selection.ClearContents
' Run my other code here
Selection.Paste ' Paste in original values, text and formulas.
End Sub
I do not think the GetFromClipboard, and PutInClipboard procedures will help me, am I wrong?
I am trying to copy a range of cells to the clipboard, then delete the range, run some code to assess the impact this has had on dependent formulas, and the paste back the original text, values, and formulas.
I would expect the simplified code to look something like this.
Sub GOGO()
Selection.Copy
Selection.ClearContents
' Run my other code here
Selection.Paste ' Paste in original values, text and formulas.
End Sub
I do not think the GetFromClipboard, and PutInClipboard procedures will help me, am I wrong?