How to refer to a variable with BLANKs

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to refer to a variable with BLANKs

FAQ

Thread Tools

Display Modes

11-05-2015, 01:28 AM

Officer_Bierschnitt Officer_Bierschnitt is offline

Windows 7 64bit How to refer to a variable with BLANKs

Office 2013

Advanced Beginner

Join Date: Oct 2015

Posts: 87

Officer_Bierschnitt is on a distinguished road

Hi,

I am getting a Runtime_error 9 "Subscript out of Range". I don't know for sure what is the reason, but that line is highlighted, so I guess it's because of the BLANK in the name.
I resorted to accessing the sheet by number, that works, but it's not very secure - anyone might add a sheet for whatever reason so the numbering would change.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting Blanks in 1 Column and Non-Blanks in Another	dogwood705	Excel	4	02-07-2015 08:45 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 09:26 AM.