How to create dynamic CopyToRange in Excel VBA?

[ImranBhatti]

Hi

Today my question is "Is it possible to create a dynamic CopyToRange in advance filter in VBA like I have two macros here

Please Login or Register  to view this content.

Here is the other one which I want to edite

Please Login or Register  to view this content.

Now required is that the result of Macro2 should be pasted to the last empty row of the result of Macro1
How can I change the line of code of Macro 2 (the bold line) to get the required results?

Your help will be much appreciated as I am stuck with this situation.

Best Regards
Imran Bhatti

[LeoTaxi]

Maybe

Please Login or Register  to view this content.

Cheers
Leo

[ImranBhatti]

Hello Leo it solved 50 % of the problem. Remaining problem is that the second result has also the headers which I don't want . The only way I found was to select the header row of the 2nd Macro and cleard its contents, select the remaining 2nd result ,cut it and paste one row up. is it possible in VBA? if yes how?...

Best Regards
Imran Bhatti

[LeoTaxi]

Please Login or Register  to view this content.

[LeoTaxi]

Please Login or Register  to view this content.

[/CODE]

[ImranBhatti]

Perfect LeoTaxi...Perfect....worked like a charm....Thanks a lot...Long live ExcelForum and its Experts.