I have a mostly working report writer which, in XL 2003 worked fine. we are
migrating our report writer to XL 2007.
At first, when calling a print preview from an array in code, the macro
would run once, but if i tried to run it a second time, excel would error out
saying "out of range" - i found out that after the first run of the code that
excel was renaming the chart to "home chart 1"...yeah...so as a workaround, I
moved the chart pages into workheets as chart objects. Now, the problem is:
When I try to print preview a sheet containing a chart object, and at the
same time, i am trying to preview a data sheet, the chart doesn't show up.
though it exists in the work view. what is going on here? am i the only
person experiencing this?
--
- Lane