runtime error 6 overflow for code can't solve.

Hi All,

I'm very new to programming but I have a data set that I'm looking to process from a code that I did not write. I continually get a 'Run-time error 6...overflow' message box pop up. When I open the debugger it highlights

nend = ActiveCell.Row. (I've bolded the line in question within the code).

The active row seems to be 65536 but my data set only goes upto 6000.

Here is a copy of the entire code

Please Login or Register  to view this content.

Any help would be greatly appreciated. For anyone with some ideas, thanks a lot in advance

Jeev

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.