#Visual basic for excel using r1c1 how to#

Let’s look at some code samples to learn some of the basics. Of course, there are more features but I don’t want to regurgitate what’s available here. Life is easier for the developer because you call a table by name (as well its columns). Excel makes life easier for a user by automatically including rows and columns in the table (if no space exists between the table and what is added). An Excel table is a contiguous range of cells. When creating Excel files, when are you not working with tables? I’m not sure but the answer if probably “often”… we’ll get to this situation later when I discuss ranges.

Working with ranges: VB.NET code examples.

Working with tables: VB.NET code samples.

#Visual basic for excel using r1c1 how to#

Today is all about Excel tables and ranges and how to do some basic automation of them. Don’t believe? Excel is gamers delight.īut I digress.

In fact, most apps in the mobile app stores these days can easily be replaced by Excel files. You can organize your data and create lists of any imaginable type. You can build models to help you think through just about anything. Microsoft Excel, being a spreadsheet application, automatically brings structure to your thinking. Believe it or not, sometimes I need the help. This is probably because utilizing them automatically enforces structure to my thinking. I think I like them because they make me feel organized. They can be an Excel spreadsheet, a table, or graph paper.