Copy Range issue in Macro

Hello,

I have a template that runs the macro in question. It has several tabs with just two of them being an issue.

I use Columns A to W on the two tabs. Columns A to P contain fixed client data (of varying number of rows - normally about 5000) and columns Q to W contain just a single Vlookup in Row 2 of each of the Columns (ie, Q2, R2, S2, T2, V2,etc).

My macro does everything correctly and the final part of the macro is to simply copy the formula's in these cells so they reach the bottom of my data so they match Columns A to P in length.

However they all seem to stop on row 2248 for some random reason?!??

All Columns from A to P contain values - there are no blank cells in Columns M, N or P. So I see no reason why the Copy Range command is stopping where it is??

Any help would be great.

The code in question with the Copy Range coding is...

Please Login or Register  to view this content.