Rick Rothstein \(MVP - VB\)
7/30/2009 3:13:00 PM
Try this...
Sub SelectColumnB()
Intersect(Range("Description"), ActiveCell.EntireRow).Select
End Sub
--
Rick (MVP - Excel)
"A & S" <stephanie.kanouse@gmail.com> wrote in message
news:309b9225-fef8-4ad7-b8af-9a1eb4a520af@k1g2000yqf.googlegroups.com...
On Jul 29, 2:17 pm, "Rick Rothstein"
<rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> Just so you can see there are usually more than one way to accomplish a
> goal
> with code, here is another approach...
>
> Sub SelectColumnB()
> Intersect(Columns("B"), ActiveCell.EntireRow).Select
> End Sub
>
> --
> Rick (MVP - Excel)
>
> "A & S" <stephanie.kano...@gmail.com> wrote in
> messagenews:bb3d7976-b974-40d4-bd5f-0fb02728c4fc@d32g2000yqh.googlegroups.com...
> On Jul 29, 1:31 pm, Lars-?ke Aspelin <lar...@REMOOOVE.telia.com>
> wrote:
>
>
>
>
>
> > On Wed, 29 Jul 2009 10:24:03 -0700 (PDT), "A & S"
>
> > <stephanie.kano...@gmail.com> wrote:
> > >Hi
>
> > >I have been messing around for several hours to try and figure out how
> > >to do this but can never get quite what I want. I need to be able to
> > >run the macro and have it select a cell by using the row of the
> > >current active cell and column B. say for instance cell D5 is active,
> > >I would want the macro to select cell B5, if F15 were active then I
> > >would want it to select B15.
>
> > >Any help would be appreciated.
>
> > >Thank
>
> > Try this macro
>
> > Sub select_B()
> > ActiveSheet.Cells(ActiveCell.Row, "B").Select
> > End Sub
>
> > Hope this helps / Lars-?ke
>
> thanks that worked just like I wanted, I knew it had to be something
> fairly simple- Hide quoted text -
>
> - Show quoted text -
I am now wondering, I highlighted the entire column B and typed
Description into the name box is there a way that I can use that
title
instead of B
thanks