how do i use a named cell for each worksheet

		Microsoft Office Forums > Microsoft Excel > Excel
how do i use a named cell for each worksheet

11-03-2015, 07:48 AM

Debaser

Windows 7 64bit how do i use a named cell for each worksheet

Office 2010 32bit

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

In the Name Manager when creating the name set the scope to that worksheet, not Workbook.

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Propagating a formula which references a named cell	Splint	Excel	4	06-15-2015 04:55 AM
getting the worksheet name in a cell	derohanes	Excel	9	02-14-2013 01:29 PM
Can't use a zero in a named cell	TechEd	Excel	2	10-16-2012 10:06 PM
Cell formating on Protected worksheet	AHB	Excel Programming	2	02-27-2012 10:25 AM
click a cell to go to a worksheet	victor	Excel	0	10-27-2006 02:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:48 AM.