Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I was reading in this other post how to set up VBA code to paste values in Excel. I understand how to create the VBA code.

I would like to set the keyboard shortcut to Ctrl d but Excel pops up an error and says this is taken when I try to utilize that.

The other post alludes to the idea that you can overwrite these or create/edit VAB code that will let you use Ctrl d without Excel knowing it is different.

I am using Excel 2010 on a PC.

share|improve this question
Can you upload a screenshot of the error? I just checked with Excel 2010 and was able to assign Ctrl+D as a shortcut to my macro just fine. What does pressing Ctrl+D do for you? Perhaps you've already assigned it to another macro? – Karan Apr 30 '13 at 18:41

If you are unable to get a macro assigned, an alternative is to either a) assign a button to your ribbon (I use that all the time), or, b) if it has to be a keyboard solution (I, too, like keyboard shortcuts), SuperUser Doug Glancy answers this with the shortcut that already exists in Excel (along with other great info) in his post:

"2.Ones like Alt-E-S-V for Edit > Paste Special > Values " (and then press Enter)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.