æåäºä¸æ®µä»£ç ï¼æè¿æ®µä»£ç å¤å¶å°ä½ è¦å®ç°åè½ç表éï¼Private Sub Worksheet_SelectionChange(ByVal Target As Range)Dim i As IntegerFor i = 3 To Range("a2").Value If Range("a" & i).Value "" Then Range("A" & i).Insert Shift:=xlToRight End IfNextEnd Sub该代ç ä»ç¬¬ä¸è¡å¼å§å®ç°è¯¥åè½ï¼ä½ å¯ä»¥å¨A2åå
æ ¼éé¢è¾å
¥ä½ è¦å®ç°è¯¥åè½çæåä¸è¡è¡æ°ï¼å¦10ï¼åè§ä¸å¾
温馨提示:答案为网友推荐,仅供参考