Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using cells property | Excel Programming | |||
How do I use the .Cells property to refer to ActiveCell? | Excel Discussion (Misc queries) | |||
Merged cells Value2 property | Excel Programming | |||
cells property | Excel Programming | |||
Using Select with Range.Cells property | Excel Programming |