arongahagan
New Member
- Joined
- Dec 15, 2005
- Messages
- 3
Hi;
In VBA, is there any way to access the row (or the cell address) of the vlookup result?
for example, i have:
...to get the value of the cell. i already know the column_index, but what i need is the row (or address) of that cell...is this possible? any creative geniuses out there?
I'm running Excel 2003 on XP pro.
TIA,
AG
In VBA, is there any way to access the row (or the cell address) of the vlookup result?
for example, i have:
Code:
dim v as double
v = application.vlookup(ein_index,table_array,column_index,false)
...to get the value of the cell. i already know the column_index, but what i need is the row (or address) of that cell...is this possible? any creative geniuses out there?
I'm running Excel 2003 on XP pro.
TIA,
AG