Excel 2007 to 2003 VBA Compatability - Modifying Coding to comply with 2003 Interface

Hi All,

First time poster, long-time viewer (different username).

I am experiencing an issue while running a macro in Excel 2003 ("Runtime error '1004' - unable to set the values property of the Series class"). The code was originally designed and used in Excel 2007 which runs without error. Due to software requirements at work, I need to convert the VBA coding to be compatible with Excel 2003.

When running the macro, a part of the code labeled "SeriesCollection" appears to be the root of the problem. I have not been able to find a work-around in the forum or from my Company's IS team, so any VBA advice to get me started would be greatly appreciated! Please feel free to reference the Waterfall worksheet uploaded in .xls (converted to Excel 2003 format).

Below is the code used in the worksheet.

Please Login or Register  to view this content.

Probably it's because your formula for Range is not in R1C1 notation. You could either:

1. Convert the formula so it generates an address R1C1 notation.

2. Use instead

Please Login or Register  to view this content.

The second approach requires less recoding.

Also, it's not a good idea to use a keyword ("Range") as a variable name.

Probably this suffices:

Please Login or Register  to view this content.