Variable to rename a tab in a worksheet via VBA

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Variable to rename a tab in a worksheet via VBA

08-04-2012, 08:14 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Variable to rename a tab in a worksheet via VBA

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

If the sheet will always be in the same position then you can use its Index instead of its Name.

eg

Code:

Sheets(1).Select

Even better, if your code is in the same workbook, you can use its codename.

eg

Code:

Sheet1.Select

To see the difference between a sheet's Name and Codename, have a look at the attachment on this thread:
https://www.msofficeforums.com/excel...html#post36290

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to Rename a Quick Part	sleake	Word	14	10-14-2013 09:21 AM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM
Rename Files	gsrikanth	Excel Programming	3	05-14-2012 03:03 AM
"Auto-populating" data-worksheet to worksheet.	meggenm	Excel	4	02-04-2012 02:04 AM
Rename File	cksm4	Word VBA	2	02-25-2011 09:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:18 PM.