I have a macro that works from the bottom of the file towards the top. A series of for/next loops copy and paste data in 100 line chuncks starting at the bottom. Works great until it gets 99 lines from top of file then it crashes.

Here's the VBA that crashes:

ActiveCell.Offset(-101, 0).Range("A1").Select

I tried
If BOF = true then end
elseif
ActiveCell.Offset(-101, 0).Range("A1").Select
end if

but that didn't work.

any ideas?

Rob