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

We support Ukraine and condemn war. Push Russian government to act against war. Be brave, vocal and show your support to Ukraine. Follow the latest news HERE