Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
3D range problem | Excel Worksheet Functions | |||
Range problem | Excel Programming | |||
Range problem | Excel Programming | |||
Used Range Problem | Excel Programming | |||
Used Range Problem | Excel Programming |