Sir Babydum GBE
08-20-2007, 05:18 AM
Hi
Hi how do I accomplish the following please:
Range("A1").FormulaR1C1 = ...
I want the FormulaR1C1 to return the current text in whatever's in the clipboard. It may not always be a simple text string in the clipboard (for example it me be that someone's copied a merged cell where normal pasting returns a "cannot change part of a merged cell" error - or it may be that there's html on the clipboard.
Is this doable?
Thanks
Hi how do I accomplish the following please:
Range("A1").FormulaR1C1 = ...
I want the FormulaR1C1 to return the current text in whatever's in the clipboard. It may not always be a simple text string in the clipboard (for example it me be that someone's copied a merged cell where normal pasting returns a "cannot change part of a merged cell" error - or it may be that there's html on the clipboard.
Is this doable?
Thanks