User-def shortcut to macro

  • Thread starter Thread starter bill
  • Start date Start date
B

bill

Using macro recorder to assign Edit/Paste Special/Values
or /Formulas to a keyboard shortcut works fine, but can't
get it to work for Edit/Paste Special/All Except Borders.
It used to work fine in Excel 97, but not 2000. Anyone
know why? Thanks!
 
Sometimes in Excel, you now have to explicitly define and set a reference (I
guess to stymie new VBA programmers). (Grin!)

Try the following code (add any other parameters that you want explicitly
set to the PasteSpecial method, separated by commas):

Sub CopyAllExceptBorders()
Dim rng As Range

Set rng = ActiveCell

rng.PasteSpecial Paste:=xlPasteAllExceptBorders
End Sub

I used a button on the worksheet to call the macro, but it should work with
a keyboard shortcut. (I am using Excel 2000, SP-3.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shortcut to macro failed 1
Failed keyboard shortcut 1
Windows 10 How to create individual shortcut for each user 1
Macro shortcuts are running macros in different open workbook 3
Macro Related to Paste Values 2
Keyboard shortcuts 3
XL 2007: How to find out what keyboard shortcuts I've assigned tomacros? 1
Assign different keyboard shortcuts 4

Back
Top