Delete Row # based on cell value

Hi,

I have a huge macro where I would like to include a line that deletes a row from a worksheet based upon the number in a cell on another worksheet. So, if the cell contains 23, then row 23 is deleted from another worksheet.

What's the syntax for something like that.

The cell is located on sheets "Intersect" at B16

and the sheet I want a row deleted from is "Trim"

any help is appreciated.

Thanks

Hey StockGobllin,

Be careful what you wish for. As I see this problem you are deleting Rows on your TRIM worksheet based on values in a INTERSECT worksheet.

When you delete those rows on the TRIM sheet they will move up. If you run your macro twice it will keep deleting different rows with no connection between the two sheets. You should really give a sample workbook so we can see how you are going to delete your data before you implement this macro.

thanks, i noticed some of my formulas changing, so I changed the DELETE to CLEARCONTENTS.

I'd like to copy the line to a new sheet before I clear it but I'm having trouble with the following code, based on your line. Do you see what's wrong?

Please Login or Register  to view this content.

Unfortunately no, I get a type mismatch error on:

Please Login or Register  to view this content.

Damn, i had #N/A in the reference (B16) cell. So sorry. It works! Thanks for all your help.