Good Day,

I would like to delete a row based on cell criteria

I would like the function to equal this:

If cell A1 = 3, Then Delete the corresponding row with the number in the first column.

For instance:

Cell a1 contains a number which output is random by that of a command button.

I also have a column that is numbered 1 through 74. If the number in cell a1 matches that of the row, then that row is to be deleted. I have been at this for a while and still cannot nail this. Any help would be greatly appreciated. Thanks.