Filling a range variable into a formula

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Filling a range variable into a formula

11-23-2015, 03:30 AM

Debaser

Windows 7 64bit Filling a range variable into a formula

Office 2010 32bit

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

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)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Object Variable or With block variable not set	Raza	Excel Programming	8	01-15-2015 12:19 AM
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge	Berryblue	Mail Merge	1	11-13-2014 05:36 PM
Run-time error 91 object variable or with block variable not set	JUST ME	Word VBA	4	03-25-2014 06:56 AM
object variable or with block variable not set	MJP143	Excel	1	02-11-2013 05:07 AM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:31 AM.