View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
jatman jatman is offline
external usenet poster
 
Posts: 88
Default delete row based on value of ...

using a macro to delete a row.

how can i delete a row if the value of a cell is 0 or less...

Column A has an item number
Column B has quantities, from a negative number, 0, and positive numbers

if a cell in Column B is 0 or lower, the row will be deleted. i can delete
rows using F5, Special, Blanks, delete row..., so i am hoping for somthing
like that where i can record a macro to work with.

thank you,

jat