Check if a value is not in a range

[dongabo12]

Hi everyone, this is my first post in this community, I aprrcieate your help in advance.

what im trying to do with a MACRO is to check how many accounts numbers are not in the sheets 2 comparing with the column account number in sheet 1
pic.png



i hope you can help me out with this. thanks

[xladept]

Hi dongabo,

Welcome to the Forum!

Here's a quickie:

Please Login or Register  to view this content.

If you haven't used macros before you'll need to go to:
File- options - trust center -trust center settings - macro settings ,
the second option down (disable all macros with notification)

Then - Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Select "Module" from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name
*Be sure to save the book with the code as Macro-Enabled

[stnkynts]

Give this a try:

Please Login or Register  to view this content.

[dongabo12]

thanks to you all, all run well.

[xladept]

You're welcome!

And, thanks for the rep!