3、Excel VBA入门与宏操作指南

丧尸225

于 2025-11-10 09:06:55 发布

阅读量9

点赞数

CC 4.0 BY-SA版权

分类专栏： Excel VBA编程入门精要文章标签： Excel VBA 宏操作代码优化

本文链接：https://blog.youkuaiyun.com/v6b7n8m9q0/article/details/155366968

Excel VBA编程入门精要专栏收录该内容

22 篇文章 ¥499.90

订阅专栏¥69.90

会员秒杀 ¥9.9 重磅福利

超级会员免费看

Excel VBA入门与宏操作指南

1. 宏代码基础

宏代码通常位于 Sub 和 End Sub 关键字之间。以下是一段示例代码：

Range("A2").Select
Selection.Style = "Neutral"
Range("B2").Select
ActiveCell.FormulaR1C1 = "Numbers"
Range("A3").Select
Selection.Style = "Calculation"
Range("B3").Select
ActiveCell.FormulaR1C1 = "Formulas"
Range("B1:B3").Select
With Selection.Font
    .Name = "Arial Narrow"
    .FontStyle = "Italic"
    .Size = 10
    .Strikethrough = False
    .Superscript = False
    .Subscript = False
    .OutlineFont = False
    .Shadow = False
    .Underline = xlUnderlineStyleNone
    .ThemeColor = xlThemeColorLight1
    .TintAndShade = 0
    .ThemeFont = xlThemeFontNone
End With
End Sub
Sub RemoveFormats()
    '
    ' RemoveFormats Macro