I appreciate your help.

I want the user to activate a cell in sheet 2 (B25 as an example), based on
contents of the active cell, I want to goto sheet 1, find the matching data
of the active cell in sheet 2 and then continue the rest of my code.

Can that be done?

"Incidental" wrote:

Hi LP

If your code is working fine and you just want to check the active
sheet you could add the If statement below into your macro, it will
check if the activesheet is "Current Month Sales" and if so it will
change it to "MasterLog 2008".

If ActiveSheet.Name = "Current Month Sales" Then

Sheets("MasterLog 2008").Activate

End If

i hope this helps

Steve