I am using VBA to format a workbook. Part of the formatting includes copying
a page and renaming it. This works fine. Then I return to original page to
add some formatting. This works fine. Then I am trying to return to the
second page and add some formatting. But I am getting a runtime error on the
first "range" line. The chart that I am trying to go to is the "Standard
Chart Data" page and I want to add text to D1.
Sheets("Standard Chart Data").Select
Range("D1").Select
ActiveCell.FormulaR1C1 = "Mean"
Range("E1").Select
ActiveCell.FormulaR1C1 = "Plus 2sd"
Range("F1").Select
ActiveCell.FormulaR1C1 = "Minus 2sd"
Range("I1").Select

Any ideas?
TIA