Thread: [Solved] Filling a range variable into a formula
View Single Post
 
Old 11-23-2015, 03:30 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
Sample of the code you have would have been useful, but essentially you just need something like:
Code:
Activecell.Formula = "=VLOOKUP(A2,Sheet2!$A$1:$F$" & your_row_variable & ",2,FALSE)
Reply With Quote