| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run a macro in active cell only. Want to place current date/time. | Excel Worksheet Functions | |||
| set the background color of the current cell(active cell) | New Users to Excel | |||
| How to add todays date (static) to the current active cell using m | Excel Discussion (Misc queries) | |||
| Populate current active cell - Help Please!! | Excel Worksheet Functions | |||
| Identify current active cell | Excel Worksheet Functions | |||
![PPL[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
