Paste Values Macro

  • Thread starter Thread starter gm
  • Start date Start date
G

gm

I want to set up a macro that will reside in personals
macro workbook that allows me to copy a cell or cells and
with a key stroke say "ctrl+a" paste what I have copied as
a value. I can't get this to work correctly any ideas on
what the macro should look like. Using excel 2002.

Thanks in adavance.
GM
 
Hi GM

You can add a button on your toolbar if you want

View>ToolBars>customize
click on the commands tab
choose Edit
Drag the Paste Values button on that list to a Toolbar
 
Create a standard module and put this code in:

Sub PasteValue()
ActiveCell.Value = "a"
ActiveCell.PasteSpecial xlPasteValues
End Sub

Then goto Tools>Macros and select this macro. Then click
Options. Put your hotkey there. Ctrl-a is select all
though, probably don't want to use that.

HTH.

-Brad
-----Original Message-----
Hi GM

You can add a button on your toolbar if you want

View>ToolBars>customize
click on the commands tab
choose Edit
Drag the Paste Values button on that list to a Toolbar



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




"gm" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Back
Top