Skip to content

RemoveRange

Jump to bottom
Henrik edited this page Apr 24, 2020 · 7 revisions

RemoveRange

If you have DynamicArray you can skip RemoveRange

If Excel does not support Dynamic Array the old data is not automaticly deleted when function is changed.
RemoveRange is a helper to clear data in RemoveRange before new data is added by formula.
This makes sure that old data is correctly deleted.

  1. Remove range must be a Range inside a string. Like "C3:G100"
  2. Don't add cell with Formula. Else Formula is deleted.

RemoveRange

The selected area will be deleted before new data is added.

See Movie.
(Starts 2min into)

Home
Installation
=BD_INSTRUMENTS()
=BD_INSTRUMENT_DESCRIPTION(InstId)
=BD_INSTRUMENTS_GLOBAL() =BD_INSTRUMENTSEARCH()
=BD_KPI_SUMMARY()
=BD_STOCKPRICE()
=BD_STOCKPRICE_DATE()
=BD_STOCKPRICE_GLOBAL_DATE()
=BD_STOCKPRICE_LAST() =BD_STOCKPRICE_GLOBAL_LAST() =BD_REPORT_QUARTER()
=BD_REPORT_R12()
=BD_REPORT_YEAR()
=BD_HISTORY_KPI()
=BD_SCREENER_KPI()
=BD_SCREENER_GLOBAL_KPI()
=BD_REPORT_CALENDAR(InstId)
=BD_DIVIDEND_CALENDAR(InstId)
=BD_HOLDINGS_INSIDER(InstId)
=BD_HOLDINGS_SHORTS()
=BD_HOLDINGS_BUYBACK(InstId)

Excel-Buttons
Common Errors
Remove Range

Clone this wiki locally