Inesert value of column B of the current row into active cell
 

Hi,
I'm trying to write a script that will insert the value of column B of the
current row into the active cell.
I've tried playing with ActiveCell and Offset and I'm getting nowhere.

Has anyone any suggestions please

TIA

Philip

Inesert value of column B of the current row into active cell
 

Hi PPL

You can use this

ActiveCell.Value = Cells(ActiveCell.Row, "B").Value


--
Regards Ron de Bruin
http://www.rondebruin.nl


"PPL" wrote in message news:5BGOf.106499$H%4.59336@pd7tw2no...
Hi,
I'm trying to write a script that will insert the value of column B of the current row into the active cell.
I've tried playing with ActiveCell and Offset and I'm getting nowhere.

Has anyone any suggestions please

TIA

Philip

Inesert value of column B of the current row into active cell
 

ActiveCell.Value = Cells(ActiveCell.Row,"B").Value

--
Regards,
Tom Ogilvy

"PPL" wrote in message
news:5BGOf.106499$H%4.59336@pd7tw2no...
Hi,
I'm trying to write a script that will insert the value of column B of the
current row into the active cell.
I've tried playing with ActiveCell and Offset and I'm getting nowhere.

Has anyone any suggestions please

TIA

Philip

Inesert value of column B of the current row into active cell
 

Thankyou both Ron and Tom. For your excellent suggestions
I am absolutely blown away with the speed of response. It took less than 8
minutes from time of posting to receiving my first reply

Wow - what can I say.
Thank you both very much - I'm a very happy guy.

Philip

"PPL" wrote in message
news:5BGOf.106499$H%4.59336@pd7tw2no...
Hi,
I'm trying to write a script that will insert the value of column B of the
current row into the active cell.
I've tried playing with ActiveCell and Offset and I'm getting nowhere.

Has anyone any suggestions please

TIA

Philip

Inesert value of column B of the current row into active cell
 

one way

ActiveCell.Value = ActiveCell.Offset(0, -ActiveCell.Column + 2).Value

--
Greetings from New Zealand
Bill K

"PPL" wrote in message
news:5BGOf.106499$H%4.59336@pd7tw2no...
Hi,
I'm trying to write a script that will insert the value of column B of the
current row into the active cell.
I've tried playing with ActiveCell and Offset and I'm getting nowhere.

Has anyone any suggestions please

TIA

Philip