[Dba-office] Excel function or macro

Thanks,
This will be used on old versions of Excel so no QAT. I did use a button
though.
I changed the title year and saved it to a file too just for good measure.
John

-----Original Message-----
From: dba-office-bounces at databaseadvisors.com
[mailto:dba-office-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, February 17, 2015 4:58 PM
To: dba-office at databaseadvisors.com
Subject: Re: [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
>
_______________________________________________
Dba-office mailing list
Dba-office at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-office