change "a" to "g"

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
something like
for i = cells(rows.count,"a").end(xlup).row to 2 step -1
if cells(i,"a")<3 then rows(i).delete
next i

--
Don Guillett
SalesAid Software

"Steve M" wrote in
message ...

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 to
delete that entire row and then move on to the next row and do the same


--
Steve M
------------------------------------------------------------------------
Steve M's Profile:
http://www.excelforum.com/member.php...o&userid=32520
View this thread:
http://www.excelforum.com/showthread...hreadid=534535