Forum Discussion

prensasarv

Copper Contributor

Nov 16, 2018

How do Count how many shapes are on a sheet?

Hello everyone, I need help with this issue, How do Count how many shapes are on a sheet?

excel

Excel Online

Formulas and Functions

office 365

fuad360

Copper Contributor

Aug 26, 2020

Jamil Hi, this is very useful for me. I'm wondering how do I list also the color of the different shapes, since I've color coded the same shapes based on color. Thanks in advanced for your help.

Jamil

Bronze Contributor

Aug 28, 2020

fuad360

Hi,

to retrieve the color, you can use my original code by adding Cells(nRow, 12) = shp.Fill.BackColor for background color and Cells(nRow, 13) = shp.Fill.ForeColor for front color