Thread: Range Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steven Drenker[_4_] Steven Drenker[_4_] is offline
external usenet poster
 
Posts: 4
Default Range Problem

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