You set rng to Sheet1!A1:A10, but then you select a Chart sheet.
You can't select a cell that is not on the active sheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Steven Drenker" wrote in
message
...
I'm having trouble understanding a simple behavior of Ranges.
In the
following snippet...

Sub test()
Dim rng As Range

Worksheets("Sheet1").Select
Set rng = Range("A1:A10")

Charts("Chart1").Select

Debug.Print rng.Address ' OK - Prints $A$1:$A$10

rng.Value = 10 ' <-- Works OK
rng.Select ' <-- Fails: Run-time Error 1004: Method
'Select' of object 'Range' failed
End Sub

If I can write to the range with "rng.Value =", why can't I
select the range
with "rng.Select"? It seems to me both should work.

Steve