Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Question
You need to replace the line...
Sheets(1).Range("rg1").Interior.Color = vbYellow with Worksheets(1) ' if the active sheet is something 'other than the 1st worksheet rg1.Interior.Color = vbYellow Hope that helps. -- Cheers, Michelle "Anyone who says he can see through women is missing a lot." Groucho Marx "Roger Converse" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Question
Oops... I just noticed that you activated the first worksheet above your if/
else statement. In that case you only need... rg1.Interior.Color = vbYellow -- Cheers, Michelle "Anyone who says he can see through women is missing a lot." Groucho Marx "Roger Converse" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range Question | Excel Discussion (Misc queries) | |||
Range Name question | Excel Programming | |||
Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
Range question | Excel Programming | |||
Range.Formula and Range question using Excel Automation | Excel Programming |