Thread: [Solved] how do i use a named cell for each worksheet
View Single Post
 
Old 11-03-2015, 07:48 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
In the Name Manager when creating the name set the scope to that worksheet, not Workbook.
Reply With Quote