ç¡®å®Aåæåä¸ä¸ªé空åå
æ ¼ï¼
dim myCell as range, i as long
set mycell=cells(rows.count,1).end(xlup).row
i= mycell.row
解éï¼
mycellå³ä¸ºAåæå1个é空åå
æ ¼
i 为å
¶è¡æ ãå¯è¿ä¸é¨ç¡®å®å
¶ä»åºåãå¦è¯¥è¡ç1~5åï¼
range(cells(i,1),cells(i,5))
该åå
æ ¼å³è¾¹ç¬¬3个åå
æ ¼ï¼
mycell.offset(0,2) æè
cells(i,3)
温馨提示:答案为网友推荐,仅供参考