Forum Discussion
Ilsss
Nov 20, 2021Copper Contributor
get.cell not work in macro enabled file--need help
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 coun...
Ilsss
Nov 20, 2021Copper Contributor
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
- glennfiresterFeb 28, 2023Copper ContributorI had the same issue today, revert to saving as explicitly to macro xlsm ad it seems to be working again. Not sure what's up