hi,
I have some code that inserts a VLOOKUP function in my spreadsheet.
the only thing is, it always goes to the 'true' part of the statement.
here's the code that inserts it:
Code:
--------------------
Columns("E:E").Select
Selection.Insert Shift:=xlToRight
lastrow1 = Cells(Rows.Count, "D").End(xlUp).Row
Range("E" & lastrow1 & ":E2").Select
Selection.FormulaR1C1 = "=IF(ISERROR(VLOOKUP(RC[-1],'PET BDC - Design Phase Dev'!D:D,1,0)), ""False"", ""True"")"
--------------------
everything comes back as "False", but if I then delete the column that
was inserted, and reinsert manually and type int he formula, it works
fine.
can anyone tell me why this might not be working...
thanks,
Matt
--
matpj
------------------------------------------------------------------------
matpj's Profile:
http://www.excelforum.com/member.php...o&userid=21076
View this thread:
http://www.excelforum.com/showthread...hreadid=537145