[电脑] Excel问题求助~~~~~~~~~~~~~~~~~~~~~~~

Sub printexcel()

Dim i As Integer
Dim iPrint As Integer

iPrint = 100

For i = 1 To iPrint

   Range("A1").Value = "SGB" & Format(i, "0000")
   ActiveSheet.PrintOut

Next

End Sub

把iprint改成打印的数量，A1改成单元格的标号
试一试