Setting a Worksheet Name as a Variable Help

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Setting a Worksheet Name as a Variable Help

11-25-2016, 08:50 AM

NoSparks

Windows 7 64bit Setting a Worksheet Name as a Variable Help

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Remove .Name from DestSh.Name

What that line is saying...
If the sheet name of the sheet being considered is not equal to the variable DestSh

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
Variable to rename a tab in a worksheet via VBA	Chayes	Excel Programming	5	08-07-2012 02:03 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 08:11 PM.