Active.Paste Error

D

DOUG

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
 
R

Rick Rothstein

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I really need help 1
Find Specific Rows in Range and Create New Tab 18
bringing up a window to make header row selections 2
Keeping Validation References When Breakingout Spreadsheets 0
Selective Macro Security in Excel 2007 0
Keeping Validation References When Breaking out Spreadsheets Using 0
Insert Row also adds formulas and moves cursor 2
Go to the Last Date in a Column 4

Top