I am trying to call a macro from a sheet using thisworkbook, however,
don't think it allows this. Therefore as a solution I just recopie
the macro that I was using into "thisworkbook". However, th
'Sheets("Charts").ChartObjects("Chart "
r).SeriesCollection(1).XValues = ' command does not seem to b
recognized in this object, so now I am unable to autoupdate the chart
which was the whole reason for this whole process. Any help in eithe
getting that command to work in "thisworkbook" or allowing me to call
macro from a sheet using "thisworkbook" would be greatly appreciated

--
blesbo
-----------------------------------------------------------------------
blesbok's Profile: http://www.excelforum.com/member.php...fo&userid=3063
View this thread: http://www.excelforum.com/showthread.php?threadid=50289