Differences

This shows you the differences between two versions of the page.

--- en:user_guide:cellrange_basic [2020/06/21 14:56]
tiger [Accessing cells and ranges]
+++ en:user_guide:cellrange_basic [2020/06/22 00:24]
tiger [Copy or Move a range]
@@ Line 76: / Line 76: @@
                    Range: $wsEmployees!B1:E#RowEnd
    Cell Set        Cell: wsSalaries!D6
-                   Value: $wsEmployees![+[$ceEmployee|column]+1][$ceEmployee|row]
+                   Value: $wsEmployees![+[#ceEmployee|column]+1][#ceEmployee|row]
 </code>
@@ Line 82: / Line 82: @@
 <code>
-[$ceFound|cell]       'refers to the found cell as Worksheet!ColumnRow
+[#ceFound|cell]       'refers to the found cell as Worksheet!ColumnRow
                       'can be used at any cell reference providing
                       'either the value or the location depending on the context
-[$ceFound|row]        'the row number of the found cell
+[#ceFound|row]        'the row number of the found cell
-[$ceFound|column]     'the column letter of the found cell
+[#ceFound|column]     'the column letter of the found cell
 </code>
@@ Line 116: / Line 116: @@
 ===== Copy or Move a range =====
-One of the most used data manipulation steps is to copy/move a range from one location to another. Djeeni has the **Copy/Move Range to** process step to carry out this operation, including the options that are provided by MS Excel itself. It can be specified if the range is coped or moved; if it overwrites the target range or will be inserted; and if only values or also formatting and values must be copied/moved.
+One of the most used data manipulation steps is to copy/move a range from one location to another. Djeeni has the **Copy/Move Range to** process step to carry out this operation, including the options that are provided by MS Excel itself. It can be specified if the range is coped or moved; if it overwrites the target range or will be inserted; and if only values or also formatting and formulas must be copied/moved.

User Tools

Site Tools

Differences

Page Tools