Re: insert formula in last cell

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

One way:

Range("C" & Rows.Count).End(xlUp).FormulaR1C1 = _
"=SUBTOTAL(9, R2C:R[-1]C)"

In article <OlN$Ja3YFHA.2420@xxxxxxxxxxxxxxxxxxxx>,
"J_Gold" <Jason_A_Gold@xxxxxxxxxx> wrote:

> Hi - I would like to be able to subtotal a column of numbers using the
> following formula:
>
> =subtotal(9, C2:?) where ? is the last cell that contains data. I would like
> to
> insert the formula in the cell below the last row of data.
>
> The data to be summed are in reports that I download daily and where the
> number
> of rows that contain data will vary. I've tried to figure out how to do this
> with a macro, but I'm stumped. Any help is appreciated.
>
> Cheers,
>
> Angela
.

Relevant Pages

  • its late (or im losing my mind)
    ... how do I set a macro to print out 4-5 reports when I close a particular ... TIA, ... Prev by Date: ...
    (microsoft.public.access.macros)
  • Re: Colored Text does not appear in Reports
    ... I do not believe that the reports are in anything but black and white. ... For Microsoft Project information and macro examples visit ... Prev by Date: ...
    (microsoft.public.project)
  • How can I send two or more reports on the same e-mail in Access?
    ... I have set up a macro to e-mail several reports however, ... on separate e-mails, is there a way to get them all to send on the same ... Prev by Date: ...
    (microsoft.public.access.macros)
  • Send multiple reports on a singe email
    ... I have reports that I run daily and send out via email. ... macro that uses the send object command to do this, ... Prev by Date: ...
    (microsoft.public.access.macros)
  • insert formula in last cell
    ... insert the formula in the cell below the last row of data. ... with a macro, but I'm stumped. ... Angela ... Prev by Date: ...
    (microsoft.public.excel.programming)