Thread: Require some codes for variable in formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
duane[_67_] duane[_67_] is offline
external usenet poster
  
Posts: 1
Default Require some codes for variable in formula

try this

ActiveCell.formula = "=VLOOKUP(A4,'input status'!$A$1
:indirect(""$Q$""&GRC2),2,FALSE)"

note I assumed cell a1 for top left of range of vlookup


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=556310

Reply With QuoteReply With Quote