GET.CELL problem in Macro enabled.xlsm file

[Ils]

Hi:

Can someone help on the below problem

I need to count each number in green and pink background color, I used the "define name" & "get.cell" yesterday, it worked well. But when I open the file today, all the "defined names" disappeared, I think it's because of the file I saved as "Excel workbook" but not "macro enabled workbook", so I saved another file with "macro enabled workbook", then the problem comes: the get.cell can't return the correct value, always tells 0

I tried both 38 and 63 for the first parameter in get.cell, could someone help to take a look on the sample mini-sheet I uploaded and tell what mistake there is & how to correct it?

Sample mini-sheet:

sample.xlsm
	N
16
Sheet1

Thanks a lot

 

[Ils]

There is something wrong with the mini-sheet I uploaded, so I upload an image with the formula

In the image:
column C-E is the cell I want to count color
row 9-31 is the defined name
column G-I is the "getcolor" which always show "0"

 

[DJunqueira]

GET.CELL is kind of problematic, you need to "wake up" it every time you try to use it. Select the cell and press F2.

 

[Ils]

GET.CELL is kind of problematic, you need to "wake up" it every time you try to use it. Select the cell and press F2.

I also noticed the need of "wake up" earlier today, thank you but it's not caused by this.
The get.cell works well in "workbook" but doesn't wok in "macro enabled workbook", I don't know why