Forum Discussion
UDF not working in Excel 365
If have allowed macros in 365
That's strange - there is no reason it wouldn't work. The function is correct (and it works for me).
mtarler Riny_van_Eekelen mathetes NikolinoDE SergeiBaklan
Does any of you have an idea? I'll attach the file here.
It also works for me without any problems.
If it doesn't work for users for whatever reason, here are some links with alternative suggestions.
How to determine and identify the background color index of cells in Excel?
Formula to find the cell color value (RGB & Color Index Value)
The GET.CELL Function (file is inserted)
Otherwise, one would have to have detailed knowledge of the digital environment in order to discover the source of the error with the elimination process.
HansVogelaar Opened the file on both PC and Mac (both MS365). Works for me even though it also shows the @sign in the beginning. Entering the formula from scratch will obviously not include the @ sign.
