Prev: Macro to Pivot data in each sheet within a workbook
Next: Workbooks.Open with a network path
From: DOUG on 14 Apr 2010 10:45
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
From: Rick Rothstein on 14 Apr 2010 11:04
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" <DOUG(a)discussions.microsoft.com> wrote in message
news:D86A92D5-2242-4BEE-A1E7-AB68DCB8DB5E(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Macro to Pivot data in each sheet within a workbook
Next: Workbooks.Open with a network path