In that case,
If there is a pattern to where you put your formulas, say for example, you want to test whether the value in column E is a formula or not, you can use...
=GET.CELL(48,INDIRECT(Sheet1!RC5,FALSE))
Or say, if you want the to use the IsFormula function immediately to the right of the value in question, you can use,
=GET.CELL(48,INDIRECT(Sheet1!RC[-1],FALSE))
Originally Posted by
Whizbang
One thing, why does it work as a named formula but not as a formula on the worksheet?
**Edit**
Also tried it as a conditional format formula, but no go. Wierd.
From what I know, the Get.Cell function is an old school macro function (xl4). This function has been removed from Excel but we can still "cheat" excel into using it and that is by using named ranges to type it in.
Bookmarks