Thread: [Solved] What IF statement required
View Single Post
 
Old 09-01-2011, 07:41 AM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

Or, the formula in those cells refers to my User Defined Formulas Add-in saved in C:\Users\Catalin\AppData\Roaming\Microsoft\Program e de completare
If the formula looks like this:
=C:\Users\Catalin\AppData\Roaming\Microsoft\Program e de completare\formule personalizate.xlam!CELLCOLORINDEX(D6;TRUE)

means that the worksheet formula uses the function stored in my computer path, not the VBA code of this workbook... (sorry for that )

for the functions to work from this workbook code, just remove the red path from cells formulas:
=CELLCOLORINDEX(D6;TRUE)
Reply With Quote