Hi

if you always just want to active the cell in column B of whatever row
you're in try

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Target.Offset(0, 2 - Target.Column()).Activate
End Sub


Cheers
JulieD

"trussman" <marcw21@msn.com> wrote in message
news:1107445850.305735.5150@z14g2000cwz.googlegroups.com...
> Help please.. This works but, I want to be able to double click
> anywhere in the same row and activate the same target(in column 2). I
> currently have 223 columns.
> Is this possible?
>
>
>
> Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
> As Boolean)
> Cancel = True
>
> Worksheets(Target.Offset(0, -15).Value).Activate
>
> End Sub
>
>
>
> Thanks in advance,
>
> Marc
>