Thread: setting row in macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Colo[_42_] Colo[_42_] is offline
external usenet poster
  
Posts: 1
Default setting row in macro
Hi pabs, if you would like to a variable in the formula written in VBA
the variable part shoud be divided by a double quote and ampersand a
follows.


Code
-------------------


"=INDEX([Master.xls]defenition!R6C1:R80C5, MATCH([Master.xls]Master!R[" & -1 * (10 + counter) & "]C[28],[Master.xls]defenition!R6C1:R80C1,), MATCH(R12C4,[Master.xls]defenition!R6C1:R6C5,))"


-------------------


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

Reply With QuoteReply With Quote