Object Variable or With block variable not set

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Object Variable or With block variable not set

01-15-2015, 12:19 AM

gmayor

Windows 7 64bit Object Variable or With block variable not set

Office 2010 32bit

Expert

Join Date: Aug 2014

Posts: 4,144

That's because you are calling column 2 of a range that only has 1 column!

The line

Code:

If marks.Cells(n, 2) < 50 Then

should read

Code:

If marks.Cells(n, 1) < 50 Then

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
XML parsing & Object variable not set (Error 91)	tinfanide	Excel Programming	0	12-29-2011 08:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:14 PM.