This issue comes up occasionally when working with the financial reporter in either FX or Adagio Ledger.

When you collapse a smarsheet, almost all the rows disappear, even those contianing your ".Range" commands. This is most likely to occur if you have been editing a sheet with the rows expanded.

To restore the sheet to its proper form, highlight the entire sheet by clicking in the top left hand corner, selecting all rows and columns. The select Format | Rows | Autofit.

The "hidden" rows should re-appear.