Hi, I am trying to get results from one sheet into another with shapes. There are 10 shapes that each corresponds with 10 “categories” in another sheet. I have named everything with corresponding numbers but it seems that you can only use Application.caller with 1 digit, 1,2,3,4,5,6,7,8 and 9 but when calling for “category10” it is only calling for the 0 at the end. Is there a way to call for the second digit as well? Any help would be great! Thank you!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Right(Application.Caller,1) run-time error
- Thread starter PecJam
- Start date
DanteAmor
Well-known Member
- Joined
- Dec 3, 2018
- Messages
- 17,837
- Office Version
- 2019
- Platform
- Windows
Hi and welcome to MrExcel
Use:
If you still have problems, come back here with more details of what you have, what you want to do and what you need as a result.
----- --
Cordially
Dante Amor
----- --
Use:
VBA Code:
Mid(Application.Caller, 9)If you still have problems, come back here with more details of what you have, what you want to do and what you need as a result.
----- --
Cordially
Dante Amor
----- --
Upvote
0
