| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
