Macro Excel 2007 to get clipboard

**pennbowl** · 12-29-2012, 02:24 PM

I wish to make a macro that will paste All from the clipboard Excel 2007 ( do the same as the Paste All Clipboard button )
The cell is A1 sheet "H"
after it has pasted there another macro to clear All (do the same as the clear all Clipboard button)
any ideas on the macro code??
Many thanks
Steve

**xladept** · 12-30-2012, 09:55 PM

Did you try recording the actions????

**pennbowl** · 01-01-2013, 04:34 PM

If you have 3 copied parts of data in the clipboard and use the paste all clipboard button all 3 parts of data are pasted underneath each other.
I would like to use a macro that when run would preform the same function.
Any ideas.
If you try to record a macro it reads as
Sub Macro2()
'
' Macro2 Macro
'

'
Range("C1").Select
ActiveSheet.Paste
ActiveSheet.Paste
ActiveSheet.Paste
End Sub

If you copy 3 pieces of data and run the macro again it will only paste the last copied data.
Thanks
Steve.

**xladept** · 01-01-2013, 06:15 PM

Hi Steve,

I haven't got 2007, but I can write routines that use the Copy method - to do so, I would need to know what you wanted to copy and where you wanted to put it - it can be, under certain circumstances, a multiple selection???