View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] nomail1983@hotmail.com is offline
external usenet poster
 
Posts: 58
Default How to find each cell with non-negative value?

I would like to manually search a long column for each cell with a non-
negative value. My intention is to delete each row with a cell that
meets that condition. Ostensibly, I would like to use Edit - Find
for this purpose. But I don't see how.

Is there any way (other than a macro) that I can find (move the cursor
to) each cell in a selected column with a non-negative value?