VBA Macro to "paste special"
 

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

VBA Macro to "paste special"
 

Stig,

ActiveCell.PasteSpecial xlPasteValues

Rob

"Stig" wrote in message
...
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

VBA Macro to "paste special"
 

Selection.PasteSpecial Paste:=xlValues

That's it. - Pikus


---
Message posted from http://www.ExcelForum.com/

VBA Macro to "paste special"
 

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....


-----Original Message-----
Stig,

ActiveCell.PasteSpecial xlPasteValues

Rob

"Stig" wrote in message
...
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


.

VBA Macro to "paste special"
 

Stig,

Chip Pearson has some examples about Clipboard manipulation he
http://www.cpearson.com/excel/clipboar.htm

Rob


"Stig" wrote in message
...
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....


-----Original Message-----
Stig,

ActiveCell.PasteSpecial xlPasteValues

Rob

"Stig" wrote in message
...
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


.