[Dba-office] Excel function or macro

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.
>
>
>
> TIA
>
> John B
>
> _______________________________________________
> Dba-office mailing list
> Dba-office at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-office
>