object variable set or not??? Challenging \ Perplexing

JohnWilson · #1 01-16-2016, 10:36 AM

Try:

If xlPath Is Nothing Then

Else

End If

zcu · #2 01-16-2016, 05:28 PM

Thanks for thinking about it.

After i posted i did troubleshooting for an hour and figured it out.

For some reason (perhaps a bug) after fill is set to user picture vba can't change the fill to rgb. So i just used a white picture instead and it worked.

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
$object variable set or not??? Challenging \ Perplexing$ 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 set or not??? Challenging \ Perplexing$ object variable or with block variable not set	MJP143	Excel	1	02-11-2013 05:07 AM
$object variable set or not??? Challenging \ Perplexing$ Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM