Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the syntax for control+UpArrow in Macro?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the syntax for control+UpArrow in Macro?
Thanks. The syntax helps. May be I should elaborate what I am trying to do.
Cell E77 is grand total of a pivot table and total line row will fluctuate depending on my filter. On cell E90, I want to add a formula of +value(E77) i.e. ControlUpArrow. I type my macro as: ActiveCell.FormulaR1C1 = "=+VALUE(ActiveCell.End(xlUp).Select)" It returns an "Application-defined or object-defined error" I type my macro as: ActiveCell.FormulaR1C1 = "+VALUE(ActiveCell.End(xlUp).Select)" It returns +VALUE(ActiveCell.End(xlUp).Select) in Cell E90 Any suggestions? "מיכאל (מיקי) אבידן" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Syntax for control source in combo box control | Excel Discussion (Misc queries) | |||
help with macro syntax | Excel Discussion (Misc queries) | |||
Correct syntax for IF, Then in a macro | Excel Worksheet Functions | |||
question about syntax in a simple macro... | Excel Discussion (Misc queries) | |||
Syntax to return the value of a control by reference | Excel Discussion (Misc queries) |