Hi as in the topic I am trying to write a code that promps a message when the value is not found in a range. I have so far:
Please Login or Register to view this content.
Hi as in the topic I am trying to write a code that promps a message when the value is not found in a range. I have so far:
Please Login or Register to view this content.
Hi there!
the LookIn you are using doesn't refer to searching area.
You should try this way:
More about .Find herePlease Login or Register to view this content.
.. and don't forget to have fun!
Bogdan.
mark SOLVED and Add Reputation if my answer pleases you
To add to bulina2k's reply, also omit after:=ActiveCell. It would trow an error if the ActiveCell was not in MyRange.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks