Hi!
I've an xls sheet with imported / pasted pictures.
These pictures have different hyperlinks in the alternative text. Every picture is in one cell.
How can I get this information in the cell under the picture?
Thanx
ER
Hi!
I've an xls sheet with imported / pasted pictures.
These pictures have different hyperlinks in the alternative text. Every picture is in one cell.
How can I get this information in the cell under the picture?
Thanx
ER
something like this perhaps
![]()
Dim Shp As Shape For Each Shp In ActiveSheet.Shapes Shp.TopLeftCell.Value = Shp.AlternativeText Next
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks