Search results
To continue a statement from one line to the next, type a space followed by the line-continuation character [the underscore character on your keyboard (_)]. You can break a line at an operator, list separator, or period.
2 maj 2013 · Assuming you only will have one series in each of these charts, you could do something like this to update the charts. How it works is by iterating over each chart in the worksheet's chartobjects collection, and then determining what Range to use for the Series Values, based on the chart's title.
2 dni temu · I'm trying to create a macro that will run through a set of column headers and look for a specific header ("CMA - ERP Variance") and calculate a simple formula for all the cells within that column header.
2 lis 2010 · It hangs up on the Application.Calculation = xlCalculationAutomatic; when I start the workbook, the calculation is already set to automatic and it hiccups when evaluating an already set flag (although why it should hang up on calculation and not any of the others is beyond me).
15 wrz 2015 · You could record an Excel VBA Macro to copy and paste as values the cells with formulas (fixing your graphs). Then a second macro to use when you want to do next month to re-insert the formulas (after you saved or exported your graphs).
28 paź 2015 · I want to insert a line in a graph the x en y data needs to come from an userform (an input box is also ok). I dont want to select a range of cells but directly enter a value (s) for the x and y data.
25 sty 2024 · Excel VBA code for graphs can help you create visually appealing and interactive graphs. Creating and optimizing graphs using VBA can improve their performance and efficiency. Troubleshooting and debugging graphs in VBA requires an understanding of common issues and their solutions.
