Chapter 2 of Automating Excel
The first question that any VBA beginner needs answering is - how do I access the data stored in the spreadsheet. The answer is easy, but it introduces ideas of objects and their properties and methods. This is where the real programming starts.
|
Read more...
|
|
Getting started with Excel VBA |
Chapter 1 of Automating Excel
When working with an Excel spreadsheet becomes repetitive you need a macro to automate the task - and for this you need VBA.
|
Read more...
|
|
|
|
|
|