<div>
<pre><code class="code-1 nolinks" id="code-20-36924267-1"><span>    Range(&quot;W10000:AA10000&quot;).Select</span>
<span>    Selection.AutoFill Destination:=Range(&quot;W10000:AA10017&quot;), Type:= _</span>
<span>        xlFillDefault</span>
</code></pre>
<br />
While waiting, I experimented with macros and found out that the above works.<br />
<br />
I do want to see if this can be done live. If then, how? Thanks!
</div>


<div>
Maybe not perfect, but have you checked whether (in Excel 20030 Tools &gt;&nbsp;Options &gt;&nbsp;Edit &gt;&nbsp;Extend data range and formula is ticked?
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have tons of formulas on nearly 20 tabs (each consisting 30 col x 1000 rows). Half of the tables are not populated with user data but the formula is there in anticipation so that if a user enters something, the fields would be populated accordingly.<br />
<br />
The problem is, my file is now 55mb. I want to reduce it and done some research. I've seen one way is to reduce redundant formulas.<br />
<br />
Is there a way to extend formula above based on a cell in a column being populated?<br />
<br />
Such that, write a macro to see if A1 is populated, then the macro would pull down B1, C1, D1, etc which would house seperate formulas<br />
<br />
I understand you can get the formula into VBA (dynamic) but I want to see if above is possibile?<br />
<br />
If then any directions is much appreciated!<br />
<br />
I've got the following code (please see below) but I want to see if this can be done live. Especially, in accordance with the user input (say user inputs 800 rows, then the formula goes down 800 rows)<br />
<br />
Thank you!<br />
<br />
Regards,<br />
Shanan
</div>
</div>


Hi,

I have tons of formulas on nearly 20 tabs (each consisting 30 col x 1000 rows). Half of the tables are not populated with user data but the formula is there in anticipation so that if a user enters something, the fields would be populated accordingly.

The problem is, my file is now 55mb. I want to reduce it and done some research. I've seen one way is to reduce redundant formulas.

Is there a way to extend formula above based on a cell in a column being populated?

Such that, write a macro to see if A1 is populated, then the macro would pull down B1, C1, D1, etc which would house seperate formulas

I understand you can get the formula into VBA (dynamic) but I want to see if above is possibile?

If then any directions is much appreciated!

I've got the following code (please see below) but I want to see if this can be done live. Especially, in accordance with the user input (say user inputs 800 rows, then the formula goes down 800 rows)

Thank you!

Regards,
Shanan

Extend formulas using macro

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.