è¶
è¿å°±è¦åæå¤ä¸ªè¡¨ï¼
Sub bb()
Dim x&, y&, i&, j&
i = Int(æ»è¡æ° / 50001 + 1) '
计ç®ä½ è¦ç表æ°
For x = 1 To i
j = x * 50000 - 50000 '计ç®æ¯è¡¨çèµ·å§è¡å¯¹åºçææ¬è¡å·
For y = 1 To 50000
Sheets(x).Cells(y, 1) = j + y
'ææ¬æ件ä¸çè¡å·ï¼è¿éåä½ è¦ç代ç ï¼j+yæ¯å¯¹åºçææ¬æ件ä¸çè¡å·
Next y
Next x
End Sub
温馨提示:答案为网友推荐,仅供参考