I have a macro that has worked fine for the last 2 years in Excel 97 i
Window NT, until I upgraded to Excel 2002 and Window XP. It gets hun
up on the activate Chart 2 statement (Chart 2 still exists). All th
macro does is set the x axis scale to values I input:

Sub Scale_Charts_Axes()

Sheets("Daily CF Chart").Select
*ActiveSheet.ChartObjects("Chart 2").Activate*
ActiveChart.Axes(xlCategory).Select
With ActiveChart.Axes(xlCategory)
.MinimumScale = Range("cashflow_begin_date").Value - 2
.MaximumScale = Range("end_date").Value + 2
End With
End Sub

I think I have all the same add-ins, but I am not sure. Is there an
add-in or VB reference that could be causing this?
Thanks, ms

--
Message posted from http://www.ExcelForum.com