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, 06:48 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

Use the VBA code name of the sheet so you will always be dealing with the same sheet no matter what the current tab name is.

Code:

Dim DestSh As String

DestSh = "The_New_Name"

With Sheet1     '<~~~~ the sheet's code name
    .UsedRange.ClearContents
    .Name = DestSh
End With

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 01:02 AM.