VBA Macro to "paste special"

  • Thread starter Thread starter Stig
  • Start date Start date
S

Stig

Hello

I would very much like to make a macro that pastes
whatever I added to my clipboard last into a cell, and
only values. I would then be able to use the menus thats
already in Excel to copy a cell, then I would run my
macro that pastes this selection with values only.

I havent been able to program this in VBA, so if anyone
know the code for this I would appreciate it very much.

Best regards
Stig
 
This doesent work. I get an runtime error. The problem is
that i need the VBA to handle whats in my clipboard. I
think maybe I need to define this too....
 
Back
Top