Avoiding Run Time Error

Hello,

I currently have a spread sheet where the user enters 'y' in the G column. If a y is entered, the user can then press the 'Update' button, and the rows containing a y in the g column will be moved to a different sheet, 'History'.

It works fine if there are y's entered into the column, but I want to be able to avoid the user getting: "Run-Time Error '1004': no cells were found" when no y's are entered into the g column.

The current code is this:

Please Login or Register  to view this content.

I have attached my work book. The following code is for Current Contractors and History Contractors, although almost the exact code is being used for Maintenance Sheets.

Please Help

Please Login or Register  to view this content.

Thank you All!

JosephP, I used your suggestion because it required the least amount of change!