I have a macro that returns a dataset from SQL that can is a minimun of 52 columns wide and 200 rows long. Based on criteria selected before running, another macro then inserts a number of columns and formulas. Excel is auto filling formula over two of the adjacent columns of sql data and messing up the report. How can I stop the auto fill function? I have already unselected Options>Advanced>Extend Data Range formats and Formulas.

Thanks