Comparing a string to values in an array resulting in a Run time Error 1004

All,

This workbook is designed to prompt the user with inputboxes allowing them to enter a name, hyperlink a file to that name, and then a date. Next all the drawing names are read into an array and stored. Along with some minor sheet formatting, this is what happens when the button "Add Drawing" is clicked.

Next, when the button "Revise Drawing" is clicked, the user will be prompted with an inputbox for a drawing name. This name will be compared to the names in the array. If the name is found, the row containing that drawing will selected and the user will be prompted to update the hyperlink, then the "drawing date" will be moved to the right by one column, then the user will be prompted for another date replacing the date that was moved.

The first sequence of commands or button works fine.

The button "Revise Drawing" prompts the user with the inputbox requesting the revised drawing name, then develops the runtime error 1004. Any ideas would be very helpful.

I have pasted the code and attached the workbook for your convenience.

Thanks for any replies.

Please Login or Register  to view this content.

You're getting an error on :

Please Login or Register  to view this content.

I don't actually know what declaring something

Please Login or Register  to view this content.

means so I don't know what else to tell ya.

Edit:
Targetrow = 0 at the time of this error.
You don't have it defined as anything so it's looking for A0.

mew!

One major step I'd look at is eliminating the .select from your code. for example:

Please Login or Register  to view this content.

Could be changed to:

Please Login or Register  to view this content.