find and replace crashes when value is not present.

**patchypich** · 10-24-2011, 01:01 PM

hello,

I created a macro that I want to use across all my workbooks, it finds abbreviation and replaces it with the full name. Unfortunately it crashes when the abbreviation I am looking for is not there. If anyone can help me I appreciate it. my code and the file is attached.

Please Login or Register  to view this content.

**shg** · 10-24-2011, 01:05 PM

Crashes on what line with what error?

**patchypich** · 10-24-2011, 01:14 PM

Please Login or Register  to view this content.

crashes at that line because "usa" is not present on the current workbook.

**shg** · 10-24-2011, 07:09 PM

Set an object variable and test it:

Please Login or Register  to view this content.

find and replace crashes when value is not present.

LinkBack

Thread Tools

Rate This Thread

Display

find and replace crashes when value is not present.

Re: find and replace crashes when value is not present.

Re: find and replace crashes when value is not present.

Re: find and replace crashes when value is not present.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions