I've been given an Excel spreadsheet which contains links to some pictures. A large number of cells have the actual file name in the value. Unfortunately many of them show "Image" as the value but the picture displays when you click on the cell. If I try to capture the value of the cell

xx = oxl.cells(row,col).value
? xx -----> "image"

If I hover on the cell I do see the file name and a message "Click once to follow. Click and hold to select this cell"

does anybody have a way that I can capture the filename associated with the cell?

thanks to all........Rich