Range Set

This step is only applicable for target worksheets. The process step Range Set (together with Cell Set) is the Djeeni counterpart of data entry on a worksheet. You can multiply a single value to a range of cells (you do not have to use double quotes to assign text values):

A value or formula can be set to a range with the following parameters:

  • Range: Complete Djeeni range reference with worksheet Djeeni name, column letter and number
  • Value / formula: MS Excel value or formula

Just like in Excel you can also assign formulas to cells by starting your value with “=”:

Please note that Djeeni considers the best practice to create your worksheet template first with formulas and then use Djeeni for filling it with data. Setting formulas in a Djeeni process is most of the time unnecessary.