I tried to reproduce the example in this post and the Indirect functions with names only work in the first columns but from the second column on it does not
I'm driving myself crazy to find out what I'm doing wrong but I don't seem to find it
I have excel 2010 and here is the file:
The problem is that your named ranges EventInfection, EventHospital,..., LengthInfection, EventHospital... are worksheet scope named ranges.
To use them you need to add the worksheet name they are from.
For the 'event' named ranges that's 'ev' so you would uset this.
Formula:
Please Login or Register to view this content.
For the 'length' named ranges it's 'length', so.
Formula:Please Login or Register to view this content.
Oh, almost forgot, you mispelt length for the length named ranges eg LenghtHospital.
If posting code please use code tags, see here.
thanks Norie !!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks