Understanding full stops better

AlexanderBB

Well-known Member
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

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Norie

Well-known Member
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

MrExcel MVP

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

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

Code:
``````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

Well-known Member
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 ?

Replies
1
Views
862
Replies
10
Views
7K
Replies
9
Views
7K
Replies
5
Views
225
Replies
0
Views
596

1,191,166
Messages
5,985,051
Members
439,935
Latest member
Monty238

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back