selection of cell at the intersection of column B and the row ofwhatever cell is active
 

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

selection of cell at the intersection of column B and the row of whatever cell is active
 

On Wed, 29 Jul 2009 10:24:03 -0700 (PDT), "A & S"
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

selection of cell at the intersection of column B and the row ofwhatever cell is active
 

On Jul 29, 1:31*pm, Lars-Åke Aspelin
wrote:
On Wed, 29 Jul 2009 10:24:03 -0700 (PDT), "A & S"

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

selection of cell at the intersection of column B and the row of whatever cell is active
 

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" wrote in message
...
On Jul 29, 1:31 pm, Lars-Åke Aspelin
wrote:
On Wed, 29 Jul 2009 10:24:03 -0700 (PDT), "A & S"

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

selection of cell at the intersection of column B and the row ofwhatever cell is active
 

On Jul 29, 1:31*pm, Lars-Åke Aspelin
wrote:
On Wed, 29 Jul 2009 10:24:03 -0700 (PDT), "A & S"

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

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

selection of cell at the intersection of column B and the row ofwhatever cell is active
 

On Jul 29, 2:17*pm, "Rick Rothstein"
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" wrote in ...
On Jul 29, 1:31 pm, Lars-Åke Aspelin
wrote:





On Wed, 29 Jul 2009 10:24:03 -0700 (PDT), "A & S"

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

selection of cell at the intersection of column B and the row of whatever cell is active
 

On Thu, 30 Jul 2009 07:03:11 -0700 (PDT), "A & S"
wrote:

On Jul 29, 1:31*pm, Lars-Åke Aspelin
wrote:
On Wed, 29 Jul 2009 10:24:03 -0700 (PDT), "A & S"

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

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


Yes, try this macro

Sub select_description()
ActiveSheet.Cells(ActiveCell.Row,
Range("Description").Column).Select
End Sub

Hope this helps / Lars-Åke

selection of cell at the intersection of column B and the row of whatever cell is active
 

Try this...

Sub SelectColumnB()
Intersect(Range("Description"), ActiveCell.EntireRow).Select
End Sub

--
Rick (MVP - Excel)


"A & S" wrote in message
...
On Jul 29, 2:17 pm, "Rick Rothstein"
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" wrote in
...
On Jul 29, 1:31 pm, Lars-Åke Aspelin
wrote:





On Wed, 29 Jul 2009 10:24:03 -0700 (PDT), "A & S"

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

selection of cell at the intersection of column B and the row
 

You can also just type into the name box one of these:
"c2 r" or "Description r" or "index(description,row())"

The equivalent in VBA is: application.goto "Description r" , etc.
An advantage is that you can use the macro recorder to generate the code.

"A & S" wrote:

On Jul 29, 1:31 pm, Lars-Ã…ke Aspelin
wrote:
On Wed, 29 Jul 2009 10:24:03 -0700 (PDT), "A & S"

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

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