How to pass cell argument from table to custum function as a range?

Question

How to pass cell argument from table to custum function as a range?

I am trying to get the following function to work by calling it from a spreadsheet cell:

=IsFormula(A1)

function IsFormula(aCell) {

  return cell.getFormula().length != 0
}

What should I do?

Dror

+5

arguments google-apps-script

user1663032 Sep 11 '12 at 13:58

source share

1 answer

Eric Koleda · Answer 1 · 2012-09-26T22:32:45+0000

Custom functions have access only to the cell value, not to the Range object. In your case, aCell will contain a cell value that will not work for your use case.

How to pass cell argument from table to custum function as a range?

More articles: