Excel & Programming

Learn more about the premier software prototyping and development environments in finance: Excel
How Excel is used to communicate complex ideas in finance
monitoring your system as you execute code

How do I get Excel to run a macro without showing all intermediate steps in a calculation? So, after I kick off the macro, there are no changes on the screen until the macro has finished...

Click to read the answer
I’m trying to plot more than one series on a chart, but I will never know in advance how many series’ will need to be plotted at runtime.
 
I’ve got the code to add the chart and 1st series in Module1.addChart
 
The problem at the moment is my Module1.addSeries, because there is no active chart.  I’ve tried code to activate / select the chart first, but it’s not having it.
I coded it this way, because before addSeries is called, it adds the actual chart, and I thought the chart was still active.
So I figured passing the chartobject as a parameter would be the best bet.
Click to read the answer
Many of the insights from software development carry over to financial modelling.

Use Excel's object model to write fast VBA code...

Syndicate content