Hello,

Im trying to find a macro that would quickly search for and delete rows
A, B, C, D and E when it finds a ! in column B. This ! exclamation mark
will be in a column with other miscelanious characters.

___A___B___C___D___E
1.|YZ |!!Z |YZ |YZ |YZ <--- exclamation mark ! found Delete A to E
2.|YZ |YZ |YZ |YZ |YZ
3.|YZ |YZ |YZ |YZ |YZ
4.|YZ |!!Z |YZ |YZ |YZ <--- exclamation mark ! found Delete A to E
5.|YZ |YZ |YZ |YZ |YZ

And so on.

Thanks,
Brian


---
Message posted from http://www.ExcelForum.com/