problem with line chart on macro

[Tla]

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!

 

[Steve Schapel]

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

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