[Dba-office] Excel function or macro

Susan Harkins ssharkins at gmail.com
Tue Feb 17 16:57:56 CST 2015

Add a macro button to the QAT and use the following statement as many times
as necessary to delete all the input ranges:

*SheetName*.Cells.Range("*cellreference*").Delete True

There might be a shorter statement.

Susan H.

On Tue, Feb 17, 2015 at 5:37 PM, John R Bartow <jbartow at winhaven.net> wrote:

> Hi All,
> Does anyone have a good solution for creating a button which clears a range
> of input cells for an Excel spreadsheet? Basically a tax prep sheet which
> is
> pretty simple and I just want to have one button to prep it for the next
> year. Maybe even add the year in a Title Cell as part of the function.
> John B
> _______________________________________________
> Dba-office mailing list
> Dba-office at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-office

More information about the Dba-office mailing list