Thread: Range Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roger Converse[_2_] Roger Converse[_2_] is offline
external usenet poster
 
Posts: 45
Default 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