View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip[_3_] Chip[_3_] is offline
external usenet poster
 
Posts: 133
Default I need a macro....I think

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