Thread: Can't fill XL Formula in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
pauluk[_30_] pauluk[_30_] is offline
external usenet poster
  
Posts: 1
Default Can't fill XL Formula in VBA
See if this cade works?

Range("K8").Select
ActiveCell.FormulaR1C1 = _

"=IF(ISNA(VLOOKUP(R[1]C[-10],R8C16:R94C17,2,FALSE)),"""",VLOOKUP(R[1]C[-10],R8C16:R94C17,2,FALSE))"
Range("K8").Select
Selection.AutoFill Destination:=Range("K8:K153")
Type:=xlFillDefault
Range("K8:K153").Selec

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

Reply With QuoteReply With Quote