'--------------------------------------------------------------------------------------------------------
'***NEW FUNCTION***
'Description: Returns text equivalent of formula in cell.
Function GetText(cell As Range)
GetText = cell.Formula
End Function
Can you expand a little on the situation? Perhaps some example formulas? Maybe a dummy example with only, say, 8-10 rows to explain what you have and what you are trying to achieve?I literally have over 1,500 rows of formulas, is there a formula to check to see if you duplicated a formula? Any help will be greatly appreciated.
Thanks!
Tamara