Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
activecell & Vlookup
Is there a way to rewrite a vlookup based on activecell?
=VLOOKUP("activecell",Sheet1!A:B,2,FALSE) where in it picks up value from the active cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
activecell & Vlookup
Right click on your worksheet and put something like this: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("A1") = ActiveCell.Value End Sub change A1 to any blank cell and refer to that cell in your formula. HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=495494 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |