get.cell not work in macro enabled file--need help

%3CLINGO-SUB%20id%3D%22lingo-sub-2988398%22%20slang%3D%22en-US%22%3Eget.cell%20not%20work%20in%20macro%20enabled%20file--need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2988398%22%20slang%3D%22en-US%22%3E%3CP%3EAnyone%20know%20about%20the%20formula%20%3CSTRONG%3Eget.cell%3C%2FSTRONG%3E%20and%20could%20help%20to%20take%20a%20look%20at%20the%20problem%20I%20have%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20count%20green%20and%20pink%20color%20for%20column%20B%20as%20attached%20in%20the%20workbook(excel%202021)%2C%20and%20the%20count%20result%20is%20in%20column%20F%2C%20it%20worked%20well%20yesterday%2C%20the%20file%20saved%20as%20%22excel%20workbook%22%2C%20but%20today%20I%20save%20another%20file%20in%20%22excel%20macro%20enabled%20workbook%22%2C%20the%20get.cell%20doesn't%20work%2C%20as%20column%20F%20should%20return%20the%20color%20code%20but%20not%200%2C%20I%20don't%20know%20why%20it%20doesn't%20work%20in%20%22macro%20enabled%22%20file%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20whether%20we%20could%20ask%20this%20kind%20questions%20here%2C%20but%20I%20didn't%20find%20anything%20that%20explain%20this%2C%20and%20I%20also%20tried%20to%20post%20in%20some%20%22excel%20forums%22%20which%20didn't%20get%20correct%20answer.%20Please%20advise%20how%20I%20correct%20it%20if%20you%20know%2C%20thanks%20a%20lot%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2988418%22%20slang%3D%22en-US%22%3ERe%3A%20get.cell%20not%20work%20in%20macro%20enabled%20file--need%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2988418%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20I'm%20more%20confused%20is%2C%20I%20create%20a%20new%20file%20%22sample2%22%2C%20as%20attached%2C%20the%20return%20value%20firstly%20shown%20as%20%23N%2FA%2C%20after%20I%20save%20it%20and%20reopen%20the%20file%2C%20the%20return%20value%20changed%20to%20%23NAME%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20someone%20know%20the%20above%20asked%20question%2C%20PLEASE%20advise%2C%20thank%20you%20so%20much%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Anyone know about the formula get.cell and could help to take a look at the problem I have?

 

I need to count green and pink color for column B as attached in the workbook(excel 2021), and the count result is in column F, it worked well yesterday, the file saved as "excel workbook", but today I save another file in "excel macro enabled workbook", the get.cell doesn't work, as column F should return the color code but not 0, I don't know why it doesn't work in "macro enabled" file

 

I don't know whether we could ask this kind questions here, but I didn't find anything that explain this, and I also tried to post in some "excel forums" which didn't get correct answer. Please advise how I correct it if you know, thanks a lot

1 Reply

What I'm more confused is, I create a new file "sample2", as attached, the return value firstly shown as #N/A, after I save it and reopen the file, the return value changed to #NAME?

 

If someone know the above asked question, PLEASE advise, thank you so much