Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active.Paste Error
What is an Active.Paste error in an Excel macro and how do I make it go away?
I am working with two lists in a spreadsheet, side-by-side. My task is to move to cell A1, filter to the row I need in column A, copy the corresponding value from column B, release the filter, and move to the first open cell in the right-hand column where I must paste the copied data. It is a dull, repetetive process which I must repeat about 100 times. A workable macro for this sure would be nice. DOUG in Wichita KS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active.Paste Error
I'm not sure what "Active.Paste" is, so I am unsure about any error that
might be associated with it. However, I'm more interested in the macro that you want to write. Had you posted your code, that might have helped us some. Anyway, if you can describe what you need to do in more detail (try not to skip or gloss over any steps... remember, we only know what you tell us), perhaps we can offer you a working macro to do it. -- Rick (MVP - Excel) "DOUG" wrote in message ... What is an Active.Paste error in an Excel macro and how do I make it go away? I am working with two lists in a spreadsheet, side-by-side. My task is to move to cell A1, filter to the row I need in column A, copy the corresponding value from column B, release the filter, and move to the first open cell in the right-hand column where I must paste the copied data. It is a dull, repetetive process which I must repeat about 100 times. A workable macro for this sure would be nice. DOUG in Wichita KS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error when cell A1 is not active and xlInsideVertical border formatthrowing error 1004 | Excel Programming | |||
Paste to active Cell | Excel Programming | |||
Paste to active Cell | Excel Programming | |||
Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
Colour active row but allow copy / paste | Excel Programming |