| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any idea why this is giving me a #Value! Error? | Excel Worksheet Functions | |||
| Giving me a error ( =REF! ) | Excel Worksheet Functions | |||
| Function giving Error | Excel Worksheet Functions | |||
| Run-Time Error: You must select a shape | Excel Worksheet Functions | |||
| Opening of an excel file is also giving a run time error | Excel Programming | |||
Linear Mode
