Do I understand you correctly that you have (approximately) 2000 cells
in column B that contain data, and that you expected a similar number
of cells in column D to contain data?

The appearance of zeroes down to the last possible row (65535)
indicates that you have entered something with column D selected, or
that you have written something in VB that has corrupted the column.

What data did you expect to be in column D?

Was the data in column B imported or manually entered, and were you
expecting more columns to be occupied?


To remove the zeroes that are currently in column D - if the whole
column is zeroes, you can select the column (click on the 'D' column
header to highlight the whole column) then, with your pointer in the
shaded area, click the Right-mouse button and select Delete.

If column D contains some good data and you just want to remove rows
(say) 2001 onwards, then enter 2001:65535 in the Name box (the small
box that shows which cell you are currently in) and rows 2001 onwards
should highlight. With your pointer in the highlighted area click the
RightMouse button and select Delete.

Does this answer your question?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=385040