this code results in a name error... if i put the actual cell reference of f92 in vlookup in place of the varibale lookupvalue it works, but i have to use a variable because the row is different each day.
a previous vba procedure figures out the rowcount of error 84 and puts it in row84count, a global variable. this procedure then correctly figures out the value for LookupValue .. my msgbox shows the right value is in lookupvalue, but the lookupfunction is not recoognizing my variable Lookupvalue. here is the code




Windows("Copy of UMJ134Errors_Today.xls").Activate


Dim LookupStartRow As String
Dim LookupStartCell As String
Dim LookupValue As String
'Dim LookupErrorCode As String

'Variable setup
LookupStartRow = Row84Count + 2
LookupStartCell = "Q" & LookupStartRow
LookupValue = "f" & LookupStartRow


MsgBox "The contents of Row84Count is " & Row84Count
MsgBox "The contents of LookupStartCell is " & LookupStartCell

'Select Cell to Begin Lookup
Range(LookupStartCell).Select

'Vlookup
ActiveCell.Formula = "=VLOOKUP(lookupvalue,Error84,10,false)"

MsgBox "The contents of LookupValue is " & LookupValue

The problem is that what you're placing as your formula in the cell is exactly what is between the quotes.

Let us assume LookupValue contains "f100". The way you have your variable set up, your active cell's formula would read:
=VLOOKUP(lookupvalue,Error84,10,false)

Another issue is Error84 a named range with at least 10 columns? I'll assume that it is.

Your code would be:
Note that the LookupValue containing the string you want (in this case "f100") added is outside your literal string quotes now. The formula in the cell would then read:
=VLOOKUP(f100,Error84,10,false)