Skip to main content

Range.AllocateChanges method

Table of contents
  1. Syntax
  2. Remarks

Performs a writeback operation for all edited cells in a range based on an OLAP data source.



expression A variable that represents a Range object.


The AllocateChanges method executes an UPDATE CUBE statement for all changes made in the range since the last apply changes operation was committed. This method generates a run-time error if it is executed on a range based on a non-OLAP data source.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>