Unable to Dim shp As Shape

[Shadal]

Hi All,
I'm not sure what I did here..

When I try to "Dim shp As Shape" vba is changing this to "Dim shp As sHape". This is causing my script to fail.

I have tried doing a replace all in project, but no matter what, I can't get the word sHape back to Shape.

Any ideas?

[cytop]

It's not causing your code to fail - the most likely cause is because you have named something as 'sHape' elsewhere or declared a variable named 'sHape'...

[Arkadi]

do you have a variable called sHape being assigned a value in your code already? sounds like a conflict of some kind... can you provide the workbook?

[CK76]

Is there class module or some add-in that's using "sHape"?

That can cause conflict. But I've never seen it. If there are no other module in your workbook...
Try cleaning up Personal.xlsb file. EDIT: (I've pranked someone by modifying Personal.xlsb. Application.Speach.Speak )

[Shadal]

Thanks guys...
I did try a 'replace all' on the entire project, even a replace all to "hhhhuuu" then from hhhhuuu to Shape, but it still ends up as sHape. I don't have any addins loaded.

Where do i find this Personal.xlsb file?

[Norie]

Do you have, or have you ever had anything, and I mean anything, named 'sHape'?

[CK76]

Please Login or Register  to view this content.

Exact location will depend on your OS/Excel version.
https://support.office.com/en-us/art...5-cf5f1d292c19

Personal.xlsb is found in "...\Microsoft\Excel\XLStart" folder, but it may be hidden. You will need to show hidden files using folder option in the explorer.

[Shadal]

Okay, so I can't find a personal.xlsb file anywhere, i'm guessing I don't have one..

Earlier I pasted the following into my code during testing, but have since deleted it.

Please Login or Register  to view this content.

[Arkadi]

never use those reserved words for your variable names... it can only cause grief... changing caps on a different letter will not really help.
Are you able to attach the workbook (remove sensitive data).
Have you done a search through all the code (project), and made sure there is no sHape left? then closed and re-opened Excel (not just workbook)

[Norie]

Try adding this, compile and then delete.

Please Login or Register  to view this content.

PS I had a similar problem and used something like this to sort things.

[Shadal]

Norie,
Thanks for your help. That seems to have fixed it!

Thanks all!!