Check whether Find returns a cell?

[dgtvr]

How do I check whether the value I am trying to find actually exists in the sheet?

[VBA Noob]

Use is Nothing statement

e.g

A message box will appear if the letter x in Range A1 to Z1 otherwise it returns not found

Please Login or Register  to view this content.

VBA Noob

[dgtvr]

thank you vm!