| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro button
Hello All,
I was just showing someone how to record a macro and experienced a strange problem. We recorded "paste_special_values" using a shortcut key and a macro button. The macro runs fine if you use the shortcut key or the macro button, but when i try to run the macro using the "Run" button a get an error "PasteSpecial method of Range class failed". Selection.PasteSpecial Paste:=xlValues,Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro button
When you run the macro using run, it clears the clipboard, so there is
nothing in the clipboard to paste. -- Regards, Tom Ogilvy "Tim" wrote in message ... Hello All, I was just showing someone how to record a macro and experienced a strange problem. We recorded "paste_special_values" using a shortcut key and a macro button. The macro runs fine if you use the shortcut key or the macro button, but when i try to run the macro using the "Run" button a get an error "PasteSpecial method of Range class failed". Selection.PasteSpecial Paste:=xlValues,Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Any ideas? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro button
Is there a reason for this? I can work around it without
a problem.....just curious. Thanks -----Original Message----- When you run the macro using run, it clears the clipboard, so there is nothing in the clipboard to paste. -- Regards, Tom Ogilvy "Tim" wrote in message ... Hello All, I was just showing someone how to record a macro and experienced a strange problem. We recorded "paste_special_values" using a shortcut key and a macro button. The macro runs fine if you use the shortcut key or the macro button, but when i try to run the macro using the "Run" button a get an error "PasteSpecial method of Range class failed". Selection.PasteSpecial Paste:=xlValues,Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Any ideas? . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro button
If you want reasons, you will have to ask microsoft.
-- Regards, Tom Ogilvy "Tim" wrote in message ... Is there a reason for this? I can work around it without a problem.....just curious. Thanks -----Original Message----- When you run the macro using run, it clears the clipboard, so there is nothing in the clipboard to paste. -- Regards, Tom Ogilvy "Tim" wrote in message ... Hello All, I was just showing someone how to record a macro and experienced a strange problem. We recorded "paste_special_values" using a shortcut key and a macro button. The macro runs fine if you use the shortcut key or the macro button, but when i try to run the macro using the "Run" button a get an error "PasteSpecial method of Range class failed". Selection.PasteSpecial Paste:=xlValues,Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Any ideas? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use Macro To Change Which Macro Assigned To Command Button | Excel Discussion (Misc queries) | |||
| Using Macro to sort without clicking on macro button | Excel Discussion (Misc queries) | |||
| use macro button to run macro in protected sheet | Excel Discussion (Misc queries) | |||
| Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming | |||
| How to end macro on inital active worksheet containing macro button that was clicked | Excel Programming | |||
Hybrid Mode
