CodingIsFun

About the companion contentThe download files for this book include all of the data sets used to produce the book, so you can practice the concepts in the book. You can download this book’s companion content from the following page:MicrosoftPressStore.co

VBA Automation for Excel 2019 CookbookSolutions to automate tasks and increase productivity with Excel and other MS Office applicationsBy Mike Van NiekerkThe code bundle for the book is also hosted on GitHub at https://github.com/PacktPublishing/VBA-Aut

代码如下：Sub MoveSheets()'在下面Array中列出所有需要复制的工作表的名称Worksheets(Array("工作表1", "工作表11", "工作表22", "工作表32")).CopySet wbNew = ActiveWorkbookWith wbNew    ActiveWorkbook.SaveAs Filename:="D:\folder_f...

如果你的Excel 工作簿内有成百上千个工作表, 要查找其中的某一个工作表会很麻烦。使用下面的VBA 代码进行查询会极大的缩短查询时间。Sub GoToSheet()Application.ScreenUpdating = False SheetName = Application.InputBox("输入要查询的工作表的名称：") Sheets(SheetName).Se...