Pressing excape isn't necessary. Select a cell with some thing and right
click and copy. If you do that is paste still greyed out.

In you VBA macro activesheet.paste will open the debug window if nothing is
copied.

Mike

"he4giv" wrote:

Yes Mike:
I hit the esc key to clear any prev. commands

"Mike" wrote:

Have you actually copied or cut something because paste will be greyed out
until you do

"he4giv" wrote:

I went to use one of my macros and the line "Activesheet.paste" gives me the
debug window so I went to the excel file, checked copy and paste and found
that I can copy but all the time my "paste" function is grayed out.