VBA - If ActiveCell.Value (from sheet 1) exists in a range in sheet 2

Hi, I tried googling this and also did a search on this forum, didnt really find what i was looking for.
Just need help on checking if a given value (im using ActiveCell.value) exists in a range from another sheet.

what i mean is:
If ActiveCell.Value from sheet 1 exists in [Range Name] in sheet 2 then
bla bla bla
End If

I know its a simple idea and thats why it frustrates me even more as to why i cant figure it out lol...

If needed, sheet 1's name is 'Assets', sheet 2's name is 'Lists', and Range name is 'Equipment'

Ive been stuck on this for a while so Please help ASAP! Huge Thanks in advance!

Hi,

Please allow me to bump this thread.

I tried the upper solution given by AlvaroSiza but I get an error message: "Run-time error 424: object required" on line

Please Login or Register  to view this content.

All of my code:

Please Login or Register  to view this content.