| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Identifying value in a cell knowing R1C1 naming
Check your previous thread.
Barb Reinhardt wrote: 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 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Identifying value in a cell knowing R1C1 naming
How about
Dim MyValue MyValue = Cells(Target.Row, Target.Column).Value Barb Reinhardt wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Identifying value in a cell knowing R1C1 naming
Barb,
Target.Offset(0,1).Value is the value to the right of the changed cell (unless target is multicell, in which case this will blow up....) myVal = Application.VLookup(Target.Offset(0,1).Value,Range ("A1:B100"),2,False) will use that value in a VLookup.... HTH, Bernie MS Excel MVP "Barb Reinhardt" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
