View Single Post
  #1   Report Post  
dmkirk
 
Posts: n/a
Default I cant get Excel OFFSET Fnct to return multiple references.

I am trying to set up dynamic charts for multiple data arrays, but the OFFSET
function will not return more than one reference. If height or width is not
1, I get a #VALUE error. Has anyone had success from "Using named ranges to
create dynamic charts in Excel" in the excel help files? I am running 2003
sp1 excel.