| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup VBA code
I am trying to use vlookup in a macro. I have to use
ActiveCell.Value = WorksheetFunction.VLookup(........) because the active cell is in a column that will continuously move to the right. Therefore I can not use a static command. For the first argument of the vlookup how can I have it reference the cell is column A of the same row. If I can get that part I think I can get the rest. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP as a vb code | Excel Discussion (Misc queries) | |||
| Using VLOOKUP in VBA code | Excel Worksheet Functions | |||
| VLOOKUP code needed please | Excel Worksheet Functions | |||
| VLOOKUP for Zip Code Ranges | Excel Worksheet Functions | |||
| how to use a VLOOKUP function in a VBA code? | New Users to Excel | |||
Threaded Mode
