VBA基础知识普及常用代码大全菜单工具栏打开关闭工作簿函数调用图表修改返回最后一行.docVIP

目 录 TOC \o 1-3 \h \z \u HYPERLINK \l _Toc393285607 前言 PAGEREF _Toc393285607 \h 2 HYPERLINK \l _Toc393285608 正文 PAGEREF _Toc393285608 \h 2 HYPERLINK \l _Toc393285609 第一部分 基本知识简介 PAGEREF _Toc393285609 \h 2 HYPERLINK \l _Toc393285610 1激活、选择对象 PAGEREF _Toc393285610 \h 2 HYPERLINK \l _Toc393285611 2引用单元格 PAGEREF _Toc393285611 \h 2 HYPERLINK \l _Toc393285612 2.1引用单个单元格 PAGEREF _Toc393285612 \h 2 HYPERLINK \l _Toc393285613 2.2引用区域 PAGEREF _Toc393285613 \h 3 HYPERLINK \l _Toc393285614 4选中/删除/剪切/插入/隐藏行或列 PAGEREF _Toc393285614 \h 3 HYPERLINK \l _Toc393285615 4.1 选中行或列 PAGEREF _Toc393285615 \h 3 HYPERLINK \l _Toc393285616 4.2 删除行或列 PAGEREF _Toc393285616 \h 3 HYPERLINK \l _Toc393285617 4.3 剪切行或列 PAGEREF _Toc393285617 \h 4 HYPERLINK \l _Toc393285618 4.4 插入行或列 PAGEREF _Toc393285618 \h 4 HYPERLINK \l _Toc393285619 4.5 隐藏行或列 PAGEREF _Toc393285619 \h 4 HYPERLINK \l _Toc393285620 5复制并粘贴 PAGEREF _Toc393285620 \h 4 HYPERLINK \l _Toc393285621 5.1 复制并选择性粘贴 PAGEREF _Toc393285621 \h 4 HYPERLINK \l _Toc393285622 5.2 复制并粘贴 PAGEREF _Toc393285622 \h 5 HYPERLINK \l _Toc393285623 6循环语句 PAGEREF _Toc393285623 \h 5 HYPERLINK \l _Toc393285624 6.1 Do While 循环 PAGEREF _Toc393285624 \h 5 HYPERLINK \l _Toc393285625 6.2 Do Until循环 PAGEREF _Toc393285625 \h 5 HYPERLINK \l _Toc393285626 6.3 For Next 循环 PAGEREF _Toc393285626 \h 5 HYPERLINK \l _Toc393285627 7 if Then end if 语句 PAGEREF _Toc393285627 \h 6 HYPERLINK \l _Toc393285628 8 With语句 PAGEREF _Toc393285628 \h 6 HYPERLINK \l _Toc393285629 9清除单元格数据 PAGEREF _Toc393285629 \h 7 HYPERLINK \l _Toc393285630 10 InputBox、MsgBox PAGEREF _Toc393285630 \h 7 HYPERLINK \l _Toc393285631 10.1 InputBox函数 PAGEREF _Toc393285631 \h 7 HYPERLINK \l _Toc393285632 10.2 MsgBox函数 PAGEREF _Toc393285632 \h 8 HYPERLINK \l _Toc393285633 11 Sub函数与Fountion函数 PAGEREF _Toc393285633 \h 8 HYPERLINK \l _Toc393285634 11.1函数结构 PAGEREF _Toc393285634 \h 8 HYPERLINK \l _Toc393285635 11.2 Sub函数与Fountion函数 PAGEREF _Toc393285635 \h 9 HYPERL