Hi Marc

in that case just use

Worksheets(Target.Offset(0, 2 - Target.Column()).Value).Activate

Cheers
JulieD

"trussman" <marcw21@msn.com> wrote in message
news:1107447681.953489.171070@f14g2000cwb.googlegroups.com...
> Thank you for the reply,
>
> Well actually I need it to activate the sheet of the employee name in
> column 2 by double clicking in any cell in the row of that employee.
>
> Thanks, Marc
>