How to change the color of cells?
I'm confused whether to use range object or cells object.
Pls give me example.
Thanks

what it this means?what is ScrollWorkbookTabs?
Private Sub Workbook_Open()
ActiveWindow.ScrollWorkbookTabs Position:=xlFirst
End Sub

So I have this spreadsheet.
In COLUMN A, there is a list of cells containing numeric & tex
information. For example:
Column A/Row 1 = 123456 Keyboards, Black

Using Excel 2003 on WinXP
I created a report card for teachers. There is a comment box which takes up
cells P2 thru T42.
PROBLEM: When a teacher types a long comment, it shows the entire comments

Hello World!
I am using Excel 2003. I did change the color of a tab to green. The
situation is that I cannot get back the initial color(beige/gray type).
Is there a simple way to recuperate without having to create a new

Can you have a cell "unlock/unprotect" when a value is entered in
another.
Ex.
Using Cells A1 and A2.

Has any one a solution for validation lotto numbers.
In row 2 for example I have up to six numbers between 1 and 50 in colums 2
to 7
In rows 5 to 10 I have random numbers between 1 and 50 in colums 2 to 7.

I'm not really a newb to excell but i just cannot get this graph to come
out right. It may seem ridiculously easy to you guys but i cannot figure
it out. This needs to be two lines on the same graph.
Force of Friction goes on the y axis

I have a formula that adds data in a column.  =SUM(A5:A10).  The proble
is that every time I copy a new row and insert it at row 5, my formul
changes to =SUM(*A6*:A10).  I just want it to stay the same.  I'v
tried using an absolute value $A$5, but it still changes when a new ro

Hi all,
Is is possible to find the ASCII characters in excel for a perticular
character?
I mean to say that, I need to insert a smiley in excel. I need this :)

Second request (not sure the first one posted)

I am dealing with database lists of hundreds of items, and one thin
that slows me down is having to paste the same URL in front of eac
individual number for each item. The numbers are not completel
consectutive (i.e. 1, 3, 4, 6, etc.). I am wondering if there's a wa

Hi, I want to refer to the contents of a cell with a variable representing
the column, but I can't figure out how to make Excel do this in A1
(preferred) or R1C1 format - sort of the reverse of the ADDRESS function.
More specifically, I want to sum the values for months of a year ...

Hi,
Please help me resolve my 2 excel 2003 related queries:
1) How do you sort by colour ? I have noted seperated info by colour
but how can I sort by colour?

Is there a way when you split your window to scroll vertically only on
one side of the split and not the other?
Thanks,
Josh