Using Named Ranges with Charts: Part 2 (!)

A

artisdepartis

HELP! Mistifyingme..... Dear All, despite invaluable help... a
persistent error occurs.

My code for one of my named ranges, lets call it Revenues_A is:

=OFFSET(INDIRECT($G$1&"!$Q$4");0;0;1;COUNTA(INDIRECT(!$G$1&"!
$4:$4")))

I have 22 named ranges in total now, which I plan to use on each of my
50+ Sheets.
Revenue_A is but one of many series of Data for my charts. Cell G1
contains the name of the sheet the Chart is on.

However... Excel persists in putting in the name of the sheet that is
active when I save my Named Range. So Excell turns it into e.g.:
=OFFSET(INDIRECT(Sheet1!$G$1&"!$Q$4");0;0;1;COUNTA(INDIRECT(Sheet1!$G
$1&"!$4:$4")))

Following the links one of you provided I still did not find a
solution. I know I can't solve it by referring to the active sheet,
since my chart will then give an error-message.

PLEASE HELP!

AdP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top