View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pgi pgi is offline
external usenet poster
 
Posts: 1
Default Excel VBA - use of ActiveCell.FormulaR1C1

I am writing a macro of which one of the statement have the following
formula

ActiveCell.FormulaR1C1 = "=IF(BK2=""PC
Number"",VLOOKUP(BN2,'O:\Documentation\Asset
Management\Hardware\[Assets -
Latest.xls]Sheet1'!$F$2:$CE$350,74,FALSE),IF(BK2=""Login
ID"",VLOOKUP(BN2,'O:\Documentation\Asset Management\User\[All
Users.xls]Sheet1'!$F$2:$Z$550,21,FALSE),""**CHECK""))"

The above was recorded using macro record and was working find. But
when trying to rerun the macro if produced an error on the syntax.

It seems the confusion here is the number of quotes ". Please advise
how best to resolve the assignment problem.


---
Message posted from http://www.ExcelForum.com/