View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Linn Kubler Linn Kubler is offline
external usenet poster
 
Posts: 13
Default cells() property?

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