VBA to check each worksheet for ending row, if final row is x...

[BGDunbar]

I am looking for code to check each worksheet in the active workbook for ending row number, if final row is x and last cell contains phone number continue, otherwise pause and allow worksheet correction. When corrected, continue through last worksheet.

I have no idea where to even start on this one. Can anyone help?

 

[BGDunbar]

PS... should say "if final row is x and last cell contains a phone number "or is blank", continue...

 

[BGDunbar]

Bump!