How to get the named range definition in Cell

  Kiến thức lập trình

Suppose I have a named Range in Googlesheets as MyNamedRange with definition as C1:H25

Now In a cell I want to show this value in cell A1 as “C1:H25”

Is it possible through some formula like MyNamedRange.getText or something like same.

Not interested in Google Apps Script to use for this.

I tried using To_Text(NamedRange) but go error.

  • google-sheets
  • named-ranges

New contributor

Rguptas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

Theme wordpress giá rẻ Theme wordpress giá rẻ Thiết kế website

LEAVE A COMMENT