Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. austen447

    Using dynamic range names in Excel Charts

    thanks for the post jdhilljr, not quite what I'm wanting to do, but I like the approach which is very user friendly.
  2. austen447

    Excel 2000 file won't open in Excel 2002

    I had a similar problem and I'm convinced there is a bug in Excel 2002 somewhere. My Excel 2000 file had similar symptoms - wouldnt open, or opened with errors and 100% cpu usage. In may case, the use of "tables" was the problem, and associated VBA code. (They ran fine in 2000 btw) I...
  3. austen447

    Using dynamic range names in Excel Charts

    Peter, thanks for the post. I'd be interested in that article; my email is jetset07 at myway.com my "aa7" cell already contains a COUNTA function set out as you suggest. Thats not the problem - the range does dynamically adjust depending how many entries are there. The problem is that...
  4. austen447

    Using dynamic range names in Excel Charts

    I want an Excel graph to automatically amend the source range, as the number of data plots in the source range changes. I have a dynamic range name that adjusts to the number of columns in the range, called "graphone" and setup under "insert-name-define" as...

Part and Inventory Search

Back
Top