I need a macro....I think

[PCOR]

I have a spread sheet that varies in length every day.
I would like a macro that would read an entire col(say Col c).If the number
100 is in col c I want to delete the entire line.
Any one give me some help with that
Thanks

 

[Chip]

Check this out...
http://www.mvps.org/dmcritchie/excel/delempty.htm

Especially the part entitled:
Delete rows with "N" in Column 31 (#Delete_N_MarkedRows)

And change the "N" to 100