Prev: Summary Help Needed
Next: Text running
From: Marvin on 15 Apr 2010 11:16
Does anyone know how to assign a named range to two seperate ranges on two
seperate sheets?
From: joel on 15 Apr 2010 11:52

Assigned Names is a workbook object and not a sheet object. What I
sometimes do is to strip off the sheet name form the named object so I
can use the object on more than one sheet.


You are trying to use the same name on two different sheet which can't
be done. What can be done is to use a cell data to identify where a
table starts. What some people do is to put on the worksheet something
like "Yearly Expense". Then use FIND to locate the cell where "Yearly
Expense" is located to find the beginning of a range of cells.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=195868

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Summary Help Needed
Next: Text running