| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why "object doesn't suppor this property or method"?
Set rCell = ActiveSheet.Range("a2")
strOutcomes = ActiveSheet.rCell.Offset(0, 3).Value Any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why "object doesn't suppor this property or method"?
strOutcomes = rCell.Offset(0, 3).Value
-- HTH RP (remove nothere from the email address if mailing direct) "davegb" wrote in message oups.com... Set rCell = ActiveSheet.Range("a2") strOutcomes = ActiveSheet.rCell.Offset(0, 3).Value Any ideas? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why "object doesn't suppor this property or method"?
Bob Phillips wrote: strOutcomes = rCell.Offset(0, 3).Value Thanks Bob! Is it that Worksheet can have a range, but activesheet can't? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why "object doesn't suppor this property or method"?
davegb wrote: Bob Phillips wrote: strOutcomes = rCell.Offset(0, 3).Value Thanks Bob! Is it that Worksheet can have a range, but activesheet can't? I think I get it. rCell already includes the activesheet as part of it's definition. Is that correct? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why "object doesn't suppor this property or method"?
That is the point Dave, the definition of rCell already contained the
worksheet so need to redo it. "davegb" wrote in message ps.com... davegb wrote: Bob Phillips wrote: strOutcomes = rCell.Offset(0, 3).Value Thanks Bob! Is it that Worksheet can have a range, but activesheet can't? I think I get it. rCell already includes the activesheet as part of it's definition. Is that correct? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why "object doesn't suppor this property or method"?
Bob Phillips wrote: That is the point Dave, the definition of rCell already contained the worksheet so need to redo it. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Object doesn't support this property or method" in Excel 2003 | Excel Discussion (Misc queries) | |||
| VBA error: "object doesn't support this property or method" | Excel Discussion (Misc queries) | |||
| Interactive Chart/ "Method Cells of object '_global' failed" | Excel Programming | |||
| Excel-VBA: "1004 - Method 'Range' of object '_Global' failed" | Excel Programming | |||
| "Select Column method or property not available because some/all of object doesn't refer to table" | Excel Programming | |||
Hybrid Mode
