1. How can I undo a Excel macro?
2. Is there any command in Excel VB similar to INKEY$ in QBASIC so that I can control user’s input key? I want to write a macro to swap two ranges’ information. The first step to move the cell pointer to the left-top corner of the first range and then press the macro shortcut key. Then highlight the range and press Enter. Then move the cell pointer to the left-top corner of the second range and press Enter to exchange two ranges’ data. If there is no similar command, would you please give me so advice?
arrow
arrow
    全站熱搜

    vbqa 發表在 痞客邦 留言(4) 人氣()