LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using cells property bigjim Excel Programming 2 February 13th 10 01:47 PM
How do I use the .Cells property to refer to ActiveCell? Caeres Excel Discussion (Misc queries) 9 October 7th 08 02:56 PM
Merged cells Value2 property Sandrina Excel Programming 1 February 6th 06 02:58 PM
cells property Souris Excel Programming 1 August 18th 05 07:50 PM
Using Select with Range.Cells property Ralph Heidecke Excel Programming 2 January 15th 05 03:05 PM


All times are GMT +1. The time now is 10:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"