ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Name of shape giving VB run-time error (https://www.excelbanter.com/excel-programming/302357-name-shape-giving-vbulletin-run-time-error.html)

Tim M

Name of shape giving VB run-time error
 
I have the following VB line that is giving me errors:

ActiveSheet.Shapes("Picture 8").Select

I suspect the problem is that the name of the shape I am
wanting it to find isn't "Picture 8".

How do I find out the name of the shape?

Thanks.

Tim

Earl Kiosterud[_3_]

Name of shape giving VB run-time error
 
Tim,

Select the picture. Look at the name box (left of formula bar).

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Tim M" wrote in message
...
I have the following VB line that is giving me errors:

ActiveSheet.Shapes("Picture 8").Select

I suspect the problem is that the name of the shape I am
wanting it to find isn't "Picture 8".

How do I find out the name of the shape?

Thanks.

Tim





All times are GMT +1. The time now is 10:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com