Need Simple VBA: Using ActiveCell to search in another sheet

Hi Guys and Gals,

I'm brand new at learning VBA and I'm having a hard time with my second ever VBA code.

Basically, I want to use whatever cell I have currently selected (ActiveCell?) as reference, to search in another worksheet called "Spare Parts" to find a match and bring me there. There will always be a match, and only one as any cell I would be selecting as reference for this search are unique 6-digit numbers. I know this is simple but I still can't figure out the proper code to manage this.

I tried recording a macro to accomplish this, but I wasn't able to get it working that way.

What range on "Spare Parts" will you be looking for the value in?
And you just want to move to that cell when the match is found?

BSB

Maybe this will point you in the right direction.

Please Login or Register  to view this content.

BSB

Wow! That worked like a charm. That code is so small, I thought I Would have needed so much more. Thank you for your help, I truly appreciate it. I'll try and dissect how this works now so I can use these tactics later.

Happy to help

Let me know if you need any of it explained.

BSB