| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving Value From Column A
Hi all -
Can anyone clue me in as to how I could get the value of a cell in column A to the active cell? E.g. if the active cell is C116, how can I read the value in A116? I've tried using the Offset property, but this seems to require the exact number of columns, whereas the active cell could be in any row. Many thanks for all/any help - I'm almost there with this!! Cheers Kelvin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| retrieving multiple corresponding values with variable rows/column | Excel Worksheet Functions | |||
| Retrieving the Column name (e.g. BT) from a numeric | Excel Discussion (Misc queries) | |||
| Retrieving data from a corresponding row from a different column | Excel Discussion (Misc queries) | |||
| VBA retrieving row and column info from user supplied range(s) | Excel Programming | |||
| Retrieving the Top 10 Average Entries by displaying a third column | Excel Programming | |||
Threaded Mode
