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
use:
Sheets(1).rg1.Interior.Color = vbYellow instead of: Sheets(1).Range("rg1").Interior.Color = vbYellow You don't need RANGE() because rg1 is already a range -- Gary''s Student - gsnu200764 "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
You've already declared rng1 as a range and in the line above the ELSE
statement you're using it as a string change Sheets(1).Range("rg1").Interior.Color = vbYellow to rg1.Interior.Color = vbYellow -- Kevin Backmann "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Question
Since I see no good reason to set your range object (unless you use it late
on somewhere) you could just use... Sheets(1).Range("A17:F17").Interior.Color = vbYellow If you really need the range object then Set rng1 = Sheets(1).Range("A17:F17") rng1.Interior.Color = vbYellow Note that you want to define the sheet when you set the range object and then you do not need to reference the sheet again. The range object knows which sheet it's on... -- HTH... Jim Thomlinson "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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Question
Appreciate it everyone, it all makes sense.
Thank you. "Jim Thomlinson" wrote: Since I see no good reason to set your range object (unless you use it late on somewhere) you could just use... Sheets(1).Range("A17:F17").Interior.Color = vbYellow If you really need the range object then Set rng1 = Sheets(1).Range("A17:F17") rng1.Interior.Color = vbYellow Note that you want to define the sheet when you set the range object and then you do not need to reference the sheet again. The range object knows which sheet it's on... -- HTH... Jim Thomlinson "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 Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
Range question | Excel Programming | |||
If Range.Name question | Excel Programming | |||
Range.Formula and Range question using Excel Automation | Excel Programming |