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

Hi Amy

See the macro add data to a existing sheet
http://www.rondebruin.nl/copy5.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message oups.com...
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