Understanding full stops better

[AlexanderBB]

This has drive me mad for years !

I want to use "With .Shape" because I have a working example giving the desired answer.

But there's other With. lines involved and in fact the very first one starts with "With r" - so it's hard to reverse engineer and factor in all the differences

My attempts invariably end up with "Run-time error '438':
Object doesn't support this property or method"

So here's the question - how can I find out what is required ahead of .Shape so it DOES support this property or method?

Thanks, ABB

 

[Norie]

Do you mean 'dot qualifiers'?

If you do then it's kind of hard to explain where they should be without seeing some sample code, also misplacing them isn't always the cause of errors like 'Object doesn't support this....'.

 

[StephenCrump]

Can you post your code?

It will probably be easier to address the specifics, and then generalise up, rather than trying to generalise down to a specific problem we can't see.

 

[AlexanderBB]

Hi, yes I imagine I do mean "'dot qualifiers'? ! But nor sure what code can I post - e.g. to use .Shape.

Dim r As Range
Set r = Worksheets("Sheet1").Range("D1")
With r.Comment
With .Shape

At this point shape is ok

End With
End With
Set r = Nothing

 

[AlexanderBB]

Continuing... (for some reason I had a window about an inch high) and could hardl see wehat I was typing.

So all that is needed to make .Shape work. How would you find this out if you didn't know ?