Posted to microsoft.public.excel.programming

Roger Converse[_2_] Roger Converse[_2_] is offline

external usenet poster

Posts: 45

Range Question

I have the following and am receiving a run time error 1004. Application
defined or Object Defined error.

What am I doing incorrectly?

Worksheets(1).Activate
If CheckBox1.Value = True Then
Set rg1 = Range("A17:F17")
Sheets(1).Range("rg1").Interior.Color = vbYellow
Else

I am trying to select the cells from A17 - F17 and highlight them yellow.

Thank you,
Roger

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Range Question	N.F[_2_]	Excel Discussion (Misc queries)	5	July 28th 07 01:05 AM
Range Question / error 1004: method Range of object Worksheet has failed	Paul	Excel Programming	3	April 7th 05 02:56 PM
Range question	mnewnam[_2_]	Excel Programming	0	October 28th 04 07:28 PM
If Range.Name question	Otto Moehrbach[_5_]	Excel Programming	8	November 30th 03 11:05 PM
Range.Formula and Range question using Excel Automation	[email protected]	Excel Programming	0	September 19th 03 04:53 AM

All times are GMT +1. The time now is 11:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us