Question

Need help with Quattro Pro X3 macro

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
Follow
Reply to: Need help with Quattro Pro X3 macro
PLEASE NOTE: Do not post advertisements, offensive materials, profanity, or personal attacks. Please remember to be considerate of other members. If you are new to the CNET Forums, please read our CNET Forums FAQ. All submitted content is subject to our Terms of Use.
Reporting: Need help with Quattro Pro X3 macro
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Comments

CNET Forums