Macro Problems for Charting in Excel 2004

[dgyoung1]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

I use macros in Excel 2004 regularly to do complex cutting and pasting, and fitting regression lines on active charts. However, whenever I have tried to set up macros to do simple x-y scatter plots of the data I routinely work with, I have been unsuccessful. Even though I make the macro relative (address), and save it to my "personal macro workbook," it only works on the specific data for which it was created. I originally called about this about 2 years ago, and was told it was an "undisclosed issue" or some such term. I'm now running vers. 11.5.2, which I believe is up-to-date, but it still eludes me. It would save me a lot of work if I could get it operating. Am I missing something; is there a way to use the Editor to correct this??

 

[JE McGimpsey]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

I use macros in Excel 2004 regularly to do complex cutting and pasting, and
fitting regression lines on active charts. However, whenever I have tried to
set up macros to do simple x-y scatter plots of the data I routinely work
with, I have been unsuccessful. Even though I make the macro relative
(address), and save it to my "personal macro workbook," it only works on the
specific data for which it was created. I originally called about this about
2 years ago, and was told it was an "undisclosed issue" or some such term.
I'm now running vers. 11.5.2, which I believe is up-to-date, but it still
eludes me. It would save me a lot of work if I could get it operating. Am I
missing something; is there a way to use the Editor to correct this??

There may be, but without seeing your code (or the relevant part of it)
it's impossible to tell