I have a number of work sheets containg coordinate data.

data is sorted in the form....

Chainage, Easting, Northing, Elevation,
1609.456 x1 y1 z1
1610 x2 y2 z2
1611.345 x3 y3 z3
1620 x4 y4 z4

ad infinitum, ad nauseum

Can anyone suggest a routine that will delete the entire row of dat
not containing whole numbers in the first column?

Thanks for any help in advance.

Rhodr

--
Message posted from http://www.ExcelForum.com