code stops working after X rows.

I'm using Excel 2007 and my s/s is 360000 rows deep.
To cut+paste formulas+formats from one column to another I'm using the following code:

Please Login or Register  to view this content.

Each time the code is run it stops working after 159050 rows and highlights (in yellow) the line:

Please Login or Register  to view this content.

Can anyone help with this??

Small XML attachment may help better understand.
Big thanks.
Colwyn.

cross-post: http://www.mrexcel.com/forum/showthread.php?t=355116

colwyn,

Please add the link to the other excel forum as cross post without the link is not permitted. Read the forum rules below before posting again

VBA Noob