---
name: "Excel::Template::Element::Range"
section: "3pm"
platform: "linux"
package: "libexcel-template-perl"
version: "0.34-3"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/Excel::Template::Element::Range"
---

# Excel::Template::Element::Range(3pm)

Excel::Template::Element::Range

## NAME

Excel::Template::Element::Range - Excel::Template::Element::Range

## PURPOSE

Returns a range of cell locations (i.e. B2:C2) that contains all calls using this reference. To return the location of the last cell, use BACKREF.

## NODE NAME

RANGE

## INHERITANCE

Excel::Template::Element

## ATTRIBUTES

- •

  REF

  This is the name of the reference to look up.

## CHILDREN

None

## EFFECTS

None

## DEPENDENCIES

This will only be used within CELL tags.

## USAGE

In the example...

```
  <row>
    <cell ref="this_cell"/><cell ref="that_cell"><cell ref="that_cell">
  </row>
  <row>
    <formula>=SUM(<range ref="that_cell">)</formula>
  </row>
```

The formula in row 2 would be =SUM(B1:C1).

## AUTHOR

Rob Kinyon (rkinyon@columbus.rr.com)

## SEE ALSO

CELL, BACKREF