摘要:
range对象代表某一单元格,某一行,某一列,某一选定区域Sub rng()Range("a2").Select '单元格Range("a:a").Select '列Range("1:3").Select '行Range("a1:b10").Select '相邻区域Range("a1", "b10"... 阅读全文
摘要:
Sub 新建工作表()Sheets.Add , , 2 自动命名Sheets.Add.Name = "hello" 直接命名End SubSub 删除工作表()Sheet1.DeleteSheets("hello").Deleteon error resume nextapplication.dis... 阅读全文
摘要:
Sub 工作簿新建()Dim wkb As WorkbookSet wkb = Workbooks.Addwkb.SaveAs ("c:\users\dalu\desktop\1.xls")End SubSub 打开工作簿()Dim wkb As WorkbookSet wkb = Workbook... 阅读全文