Objects are much more interesting than are numbers because there is much more to say about then. Think of Objects as things like a chair or a car or a sweater. Don t memorize the properties, but do understand the idea. If you are with me, you may be wondering how do we get access to these properties. The following function, which I call findrownumber, illustrates how to find the first row number of any range.
Every object has a name.
To find information about these properties, go back to findrownumber and highlight the row property of datarange. While Row is highlighted hit F1 and the Visual Basic Information should show up. Read the information and look at the example. The Row property tells us the number of the first row in any range. I created a function called findcolnumber.