I am trying to record a simple macro to make a line chart showing date (x-axis) and data value (y-axis). I want to use the same macro in many worksheets. The work sheet formats are identical. I assume I should be specifying relative cell references in the macro because I want to use the macro in different worksheets from the worksheet in which it was created. However, when I run the macro in a worksheet different from the worksheet in which it was recorded I get an error that I cannot decipher:
'Run time error 1004
Application defined or object defined error'
The help screen is Greek to me. I don't know VB. Any ideas?
Bookmarks