Hi Linn,
You are not the first to be confused by this!
Cells is a Property of the Range object
Range.Cells(1,1) can be shortened to Cells(1,1) but the latter still
represents a Range property.

I Googled "Excel VBA Cells" and found some site that might help you. One of
them s
http://www.anthony-vba.kefra.com/vba/vbabasic2.htm

best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Linn Kubler" wrote in message
...
Hi,

I'm confused. I'm working with Excel 2003 and trying to manipulate cells
on a worksheet. Looking at the Excel 2003 VB Reference documentation I
see examples like the following:

Worksheets("Sheet1").Cells(5, 3).Font.Size = 14
Worksheets("Sheet1").Cells(1).ClearContents

Now to me that means that Cells() is an object because it has properties,
.Font.Size, and methods, .ClearContents. However, in the documentation
all I can find is a Cells property, how can this be?

What I would like to do is find a listing of all the "properties",
"methods" and "events" of the Cells property. How do I go about changing
font color, size, cell shading, borders and what-not of a cell?

Like I said, I'm a bit confused.

Thanks in advence,
Linn