Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to do something very simple. I go to a sheet and select a range
and click copy to copy a range. I switch to another workbook and click a button. The code attached to the button should paste values into the active sheet starting at cell "A3". It's ridiculous because this should be easy; I even recorded a macro to do this and the recording fails. Microsoft hasn't improved this yet????? Here is some of the code I've tried: ActiveSheet.Range("A3").PasteSpecial Paste:=xlPasteValues Cells.PasteSpecial Paste:=xlPasteValues ActiveSheet.Range("A3").PasteSpecial xlPasteValues Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Any help appreciated... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find matching values, copy/paste values as well as values in ColA | Excel Programming | |||
Toolbar Gone - STUPID STUPID STUPID!! | Excel Programming | |||
Toolbar Gone - STUPID STUPID STUPID!! | Excel Programming | |||
Toolbar Gone - STUPID STUPID STUPID!! | Excel Programming | |||
Stupid, stupid question.... | Excel Programming |