Macro Code problem when Copying Selected (variable) cells with filters

Hello,

I have a Macro which works perfectly well except one thing...

I have one file that each day has the previous days data uploaded over night. Therefore this data file will always vary in rows (columns will always be the same). My Macro does everything I need it to, except the macro doesn't seem to register that each day there may be more rows down than when I created the Macro. The macro is pretty big so I won't paste it all into here. But the coding where the issue lies is as follows...

Please Login or Register  to view this content.

Now when recording this macro I specifically used the 'Selection.End(xlDown).Select' as I thought this would always find the end of the cell values within the filtered data for me to then CTRL+SHIFT and UP to capture all of the data. But everytime I run it, the 'Selection.End(xlDown).Select' command doesn't go any further down the data than when I recorded this macro?? it now seems to stop at a specific row and some of the data (within the filtered data) is left behind and not copied onto the other workbook.

Any thoughts?? It is purely an issue with the active range not always finding the end of the data within the filter.

Regards

The range to copy is hard coded as A2:X10512 and the range to filter is hard coded as $A$1:$AS$20253.

The code needs to be changed to take into account the changing no of rows.

I'll post some code but could you add code tags to the code you posted?

Code tags