I am running a routine which checks every cell in my model
and based on certain search criteria pastes the results
(cell address) in a summary sheet in column B.

The routine works well until I use a very large model.
The code generates an application error 1004. In this
instance, the routine has pasted cell address all the way
down to row 65,532 of column B in the summary sheet.

I am wondering if this error is being generated due to the
fact that I have 65,532 cells with data (i.e. memory
issues). I do not het have error handling in that puts an
Excel row constraint (65,536)into the paste routine

Can anyone tell me what is going on and how to get around
this?