Copying, Pasting Autofilter results to a region more specific than a specified worksheet.

F

feature86

Hello,

I'm trying to integrate the results from an autofilter with other data
and want the autofilter results to paste below the other data. I
wonder if anyone can help me solve this problem.

So far, I've only been able to get VBA to paste the autofilter results
at the top of the desired worksheet. Excel says that's because I have
to specify exactly the region I want VBA to paste it in. The trouble
is, I can't figure out how to select that region --which I want to
start on around row 20 and of course, will vary in length depending on
how many rows of data the autofilter returns.

Any ideas would be greatly appreciated.

Best,
Amy
 

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

Autofilter More than One Worksheet 2
Trying to paste into a worksheet 1
Using Autofilter More Than Once 3
Copying Data into another worksheet using macro 1
Pasting into a filtered region 1
copying pivot table results to a new sheet. 1
Pasting a worksheet function in VBA. 1
Pasting Subtotal Results 1

Top