View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default How to find each cell with non-negative value?

Apply datafilterautofilter, from dropdown select custom and less than 0
select all visible rows after you filtered the list and delete them (make
sure you select entire row), then clear the filter

You might want to do this on a copy to make sure you get it right


--
Regards,

Peo Sjoblom




wrote in message
ups.com...
On May 14, 6:14 am, "
wrote:
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?


If this cannot be done without a macro, can someone offer a macro that
might move down a column starting with the selected column, selecting
(moving the cursor to) the next cell that has a non-negative value?