What is the syntax for control+UpArrow in Macro?
The basic commend is:
ActiveCell.End(xlUp).Select
Try to fine-tune it to your needs.
Micky
"AL" wrote:
I am trying to write a macro to fill a cell formula with +value(cell located
at Control+UpArrow) which reference the grand total line of a pivot table.
The row number may change after refresh so something like R[-7]C would not
work.
|