Thanks,
Dave
Application.Calculation = xlCalculationAutomatic
Worksheets("Graph").Activate
Application.Calculate
Sub Output()
Application.Calculation = xlCalculationManual
' Stops the graph from updating as each of the 1000 points is added to the sheet
' Calculate and write the 1000 points into the Graph worksheet
...
' Set the label for the percentile marker in the cell B3 which the data label is referred to
Worksheets("Graph").Activate
Cells(3, 2).Value = "P" & Format([n15] * 100, "##") & "=$" & Format([n16], "#0.0") & "M"
Cells(3, 2).Characters(Start:=2, Length:=2).Font.Subscript = True
Application.Calculation = xlCalculationAutomatic
Worksheets("Graph").Activate
Application.Calculate
End Sub
Title | # Comments | Views | Activity |
---|---|---|---|
Excel macro sheet auto run and save to xlsx | 5 | 17 | |
Copy the formula in excel | 8 | 28 | |
In Excel 2007, how do I need to correct this ampersand formula so it works? | 2 | 14 | |
Delete rows if they are duplicates | 3 | 13 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!