| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying value in a cell knowing R1C1 naming
I am using a worksheet change event and am getting row and column data from
the target value. What I want to do is get the value that is in the following location and ultimately use it in A VLOOKUP. What am I doing wrong? Set Value.address = "R" & Target.Row & "C" & (Target.Column + 1)) This value will be used as a constant in an Application.WorksheetFunction.VLookup() function |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I change cell labelling from R1C1 to A1? | Excel Discussion (Misc queries) | |||
| How do I change default cell reference from 'R1C1' to 'A1'? | Setting up and Configuration of Excel | |||
| Using a cell value for row in R1C1 | Excel Worksheet Functions | |||
| How to make R1C1 nomenclature work with SUM() in a cell ? | Excel Programming | |||
| Getting the value from a cell, and then using it as a name or R1C1 reference | Excel Programming | |||
Threaded Mode
