Thanks to Charlie Cork for his great book on QP Formulas, Functions and Macros. (Search this forum for: Quattro Pro Formulas,
Functions, and Macros)
I wanted to place a value in the first blank cell at the bottom of a column of data, using a macro. (I usually just make macros by recording keystrokes and then modifying the results, but this is a little trickier.)
Of course, he tells you just how to do that on page 124, "How to move to the first blank cell at the bottom of a column of data."
I don't completely understand the syntax of the @offset command:
The Help file for QP Functions gives syntax for @offset as:
@OFFSET(Reference, Rows, Cols, <Height>, <Width>)
But in the example (which works), it looks like Cols comes before Rows.
Is the Help file wrong?