| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What's wrong with this bit of code
I am trying to change a cell to a new value derived from looking itself up
in a list and cannot work out how to do it without using a temporary cell to hold the original data and then lookup using this. I cannot see why the following does not work! Dim tempvar Cells(2, 5).Select tempvar = Cells(2, 5) ActiveCell.FormulaR1C1 = "=VLookup(tempvar, CodeLookup, 2, True)" 'CodeLookup is a list Can anyone help please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is wrong with this code? | Excel Discussion (Misc queries) | |||
| What is wrong with the code? | Excel Discussion (Misc queries) | |||
| Can someone tell me what is wrong with this code? | Excel Discussion (Misc queries) | |||
| What's wrong with my code ? | Excel Worksheet Functions | |||
| Is something wrong with the code | Excel Programming | |||
Threaded Mode
