Hi,
After cutting and pasting a column from a Table, the formulas that were referring to the mentioned column, stick to the now empty column.
For example I have a column named A, I cut it and paste it but the cells referring to A now refer to Column1 which is the default name excel assigns to...
VBA Code:
Function MyExample (mystring1 As String)
Dim mynumber As Single
If mystring1 = "A" Then
mynumber = 1
Else
mynumber = 2
End If
If mynumber = 1 Then
'What I want to do is change the font color of the cell containing this UDF...