Check size of an Image in a Cell
Hi,
Is there a way to know whether the cell has an image ... If it has can I get the size of the image and then mark the result as number (o or 1).
Best regards
Hassan
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 686 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Check size of an Image in a CellHi, Is there a way to know whether the cell has an image ... If it has can I get the size of the image and then mark the result as number (o or 1). Best regards |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
cell has image
Hi Hassan
Yes, this is possible with VBA... however it's quite a lot of work, so I won't be able to provide you with a free solution. (Request a quote for consultancy)
Conceptually you would do it via looping through the shapes collection, and checking the .left property, and comparing that with the .left of the cell.. similar for .top
Nick