Menu

Font color setting problem

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

geofflilley geofflilley is offline

geofflilley is offline

external usenet poster

Posts: 1

Default

Font color setting problem

;7516647 Wrote:
I am trying to set the color of a range of cells based on the number
of a looping variable (Count). The following code gives me an
error indicating that the color can't be set using a variable name.
What would be an alternate way to do this?

For Count = 1 To 60

Sheets("Sheet3").Select
Range("B5").Select
Selection.Font.ColorIndex = Count

Thanks.

I think what you probably want to do is something like this:

Sub setColor()
Sheets("Sheet1").Select
Range("B5").Select
For Count = 0 To 56
Selection.Font.ColorIndex = Count
ActiveCell.Offset(1, 0).Activate
Next
End Sub

Problem is that the colors only go up to 56. I suspect the error that
you're getting is "unable to set colorindex property of the Font class."
That's kinda misleading. You CAN use the counter as you outlined
above; the problem is that you're asking the code to set the ColorIndex
to a number that it can't do.

HTH

Cheers
Geoff

--
geofflilley

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Problem with setting Interior Color in VBA	cneumann	Excel Programming	4	December 14th 05 03:37 PM
Problem with setting Interior Color in VBA	cneumann	Excel Programming	2	December 13th 05 10:56 PM
Problem setting font size	Edward Ulle	Excel Programming	2	March 3rd 05 03:23 PM
Problem in setting Cell Interior Color filling.	Venkatachalam	Excel Programming	1	September 29th 04 07:13 PM
vba: setting font color to entire sheet	chick-racer[_35_]	Excel Programming	3	November 17th 03 04:34 PM

All times are GMT +1. The time now is 09:15 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement