[Dba-office] Excel function or macro

Susan Harkins ssharkins at gmail.com
Wed Feb 18 06:50:35 CST 2015


Glad to help. :)

Susan H.

On Wed, Feb 18, 2015 at 2:11 AM, John R Bartow <jbartow at winhaven.net> wrote:

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


More information about the Dba-office mailing list