Deleting Row Macro

S

Steve M

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
 
D

Don Guillett

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
 
D

Duke Carey

Insert a new column adjacent to your data and use it to insert row #s for all
your data. Now sort on column G so that all the rows less than 3 are in a
contiguous range. Delete them. Now sort on the rows numbers to restore your
data to its original order
 
Top