Modelling course

Here you can find out more about our Excel financial modelling course training.

Search our site

Or you can search our site for finance training topics.

 

Object

Excel does its work on “Objects” (= parts or components of Excel). A cell is an example of an object, as is a “Range” of cells (actually they might be the most common objects you end up targeting with your macros). There are lots and lots of...

Call

We “Call” something when we start to “Run” macro “Code”. Call really means the same as run. Sometimes we call one macro from another macro. If you want to call a macro from a macro you’ll have to think about how you declare...

With

The statement “With” followed by “End with” enables you to save yourself some typing. Often if you’re using the “Macro recorder” you will notice that it abbreviates code using these statements. Alternatively, you can include...

Variables

We’ve tried to explain macro variables as well as we can. They’re little storage baskets that act as temporary store areas while your macro is running. You’ll get into the hang of it soon and find yourself creating variables all over the place...
Page 20 of 69« First...10...1819202122...304050...Last »