Why "object doesn't suppor this property or method"?
 

Set rCell = ActiveSheet.Range("a2")
strOutcomes = ActiveSheet.rCell.Offset(0, 3).Value

Any ideas?

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?

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?

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?

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?

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!