View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve M[_14_] Steve M[_14_] is offline
external usenet poster
 
Posts: 1
Default Macro to Delete Row based on <3


I have a spread sheet with data in A:A to G:G

I want a macro that will check the value in G and if its less than 3 t
delete that entire row and then move on to the next row and do the same

So if G5 is 2 it deletes A5:G5 then moves onto the next row

Any help appreciate

--
Steve
-----------------------------------------------------------------------
Steve M's Profile: http://www.excelforum.com/member.php...fo&userid=3252
View this thread: http://www.excelforum.com/showthread.php?threadid=53454