How do I jump to the last filled cell in a range?

  • Thread starter Thread starter Naomi
  • Start date Start date
N

Naomi

I want to get a subtotal at the end of a row from a pivot table. If I were
to record the macro using the keyboard, use control-end to jump to the end of
the row (which doesn't account for changing ranges and remains absolute the
next time the macro is run), can I insert the correct formula later? I don't
write anything in VBA - I only take peeks and then alter a few words here or
there.

And what would that formula be?
thanks.
 
Back
Top