Hi SP69,

if you have chart name only and you want to get the worksheet name then only way is to navigate through all the sheets which you already did.

Thanks