Thread: refering to a variable in a cell.formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cw cw is offline
external usenet poster
  
Posts: 4
Default refering to a variable in a cell.formula
Hi All

I just have a quick question, is it possible to refer to a variable in the
formula below

where B1 is after MATCH, I want that to match the variable 'i' in the
Cells.(i,9)

ActiveSheet.Cells(i ,9).Formula = "=MATCH(B1,'Brand list'!B$1:B$1861, 0)"

Thanks
Craig





Reply With QuoteReply With Quote