4 line charts are created using 3 columns for each graph as the data source.
while recording- these graphs come out fine, but when i replayed it- it did
not work. the debugger pointed this out:
ActiveChart.SetSourceData Source:=Range( _
"Sheet3!$A:$A,Sheet3!$E:$E,Sheet3!$E:$E,Sheet3!$Z:$Z")
help!

Tla,

The focus of this newsgroup is macros in Access, the database program, and
these are very different from Excel macros. You will have a better chance
of getting good help in an Excel newsgroup.

--
Steve Schapel, Microsoft Access MVP


"Tla" <(E-Mail Removed)> wrote in message
news:E82B76C4-0A86-4093-AA7D-(E-Mail Removed)...
> 4 line charts are created using 3 columns for each graph as the data
> source.
> while recording- these graphs come out fine, but when i replayed it- it
> did
> not work. the debugger pointed this out:
> ActiveChart.SetSourceData Source:=Range( _
> "Sheet3!$A:$A,Sheet3!$E:$E,Sheet3!$E:$E,Sheet3!$Z:$Z")
> help!



__________ Information from ESET Smart Security, version of virus signature database 4193 (20090626) __________

The message was checked by ESET Smart Security.

http://www.eset.com