Understanding full stops better

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,835
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
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

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
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....'.
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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 ?
 
Upvote 0

Forum statistics

Threads
1,213,549
Messages
6,114,261
Members
448,558
Latest member
aivin

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top