check a row of data for a value return a boolean result

[js999]

I need help to determine if a value exists in a column header and then based on that determination give it a boolean value (TRUE = it exists, FALSE = it doesn't exist) and then, if it does exist, store that column location into an integer variable.

My problems occur when the column name doesn't exist. Since there is no value, it can't determine if the value is > 0 so it hangs.

Any help would be appreciated.

-js999

Please Login or Register  to view this content.

[Leith Ross]

Hello Js999,

The Find method returns a Range. If the Find is unsuccessful then it returns a special value called Nothing.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[js999]

Leith,

Thank you! It works perfect. Hopefully, someday I will get to the level where I can return the favor. Emphasis on 'someday'.

-js999