All articles with 'activecell' Tag

How to use Cells, Ranges & Other Objects in Excel VBA

Published on Aug 31, 2011 in VBA Macros
How to use Cells, Ranges & Other Objects in Excel VBA

In part 3 of our VBA Crash Course, we are going to learn how to speak with various Excel objects like Cells, Ranges etc. and deal with them.

Objects – what are they?

Any thing and everything is an object. Your dog, your bed, your neighbors cat, their car, your bike, your computer, the shiny new Excel workbook you just created, my website, your email account – every thing is an object.

From our “We are nuts” example yesterday, you can already see these objects:

One awesome owner (that is you)
24 store manager objects
24 store objects

Continue »