Filling a range variable into a formula

Debaser · #1 11-23-2015, 03:07 AM

Can you provde more information as to exactly where you need the variable to be used?

Officer_Bierschnitt · #2 11-23-2015, 03:10 AM

Hi Debaser,

well, I needed it as one parameter specifying the lookup_range (the array where to look for the value).
I solved this, however, by just giving that range a name using the Excel_name_manager and specifying that name in the formula.
The case is thus solved ;-)

Thanks anyway!

Best regards,

Officer_Bierschnitt

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