Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

Need help with Quattro Pro X3 macro

May 31, 2011 6:09AM PDT

I want to select a variable sized column and get a minimum value in it.

I tried using the Relative Reference Macro option but that still only gave me a static reference in my macro. If I add data to that column the macro will not update to the new block of the entire column.

I see it somewhat this way if I could use a true keyboard copy in my macro.

{SelectBlock TOP} to get me to cell named TOP at the top of my column
{End}{Down}{R} to get me to the current bottom of the column and move right one column to where I want the next formula to display its results
@MIN({D}{L}{U}(anchor block pointer){END}{U}){ENTER}
to find the minimum of the following block: Move back to the bottom of the column, anchor the block, and select the column all the way to the top.

Discussion is locked