PDA

View Full Version : Deleting a row after a search?


goodsboy
09-04-03, 00:22
This thing has me stuck.. I have been looking at VBScript all day and still not finding it.

In one worksheet I want to run a search for a value in the "B" column. Then when I find it, I want to delete that entire row.

After Im done with that I want to find all the blank lines and delete those (a sort wont work here since there are multiple rows used to describe a single record).

Can anyone help? I know this is basic but all the examples I find include a specific field of cells, which I wont know till after the search is run.

goodsboy
09-04-03, 01:40
Great, I figured this out with the help of another thread I found. Thanks anyways!