In a sheet with many formulas, each of which is of the form =[filename]sheetname!{cell address}, I want to return the cell address portion of the formula. Any suggestions?
Thanks.
George
In a sheet with many formulas, each of which is of the form =[filename]sheetname!{cell address}, I want to return the cell address portion of the formula. Any suggestions?
Thanks.
George
Sorry. Thought that if it wasn't here it wasn't.
Found thishere.![]()
Function GetFormula(Cell as Range) as String GetFormula = Cell.Formula End Function
g
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks