Deleting Row containing YES added to an existing macro for input

[stephenwalter]

Good Afternoon, I am a novice to excel and i am looking to add a delete row to function to the invoiced macro. If a yes is added to the Hire Regester sheet via my Invoice Macro i would like it to delte the whole row is this possible. any advice would be greatly received. Thaks in advance

[rollis13]

Have a try, in your Module3 code change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

Also, starting with x=7 would be better since your data is from row 8.
And why ".UsedRange.Rows.Count + 20" ? wouldn't ".UsedRange.Rows.Count - 1" be better.

[stephenwalter]

Rollis,
Thanks very much, like i said am new to all this I am using formulas i have found on the web and ones from peoples help and trying to adjust them to my needs.

whats the difference between ".UsedRange.Rows.Count + 20" ? wouldn't ".UsedRange.Rows.Count - 1"

[rollis13]

What you need in your macro is determine the last used row so you can end the macro when all data has been checked. With lastrow+20 you are adding an extra 20 empty rows to be unnecessarily checked so, since your last row is a note, what you need is lastrow-1.