More than 5 years have passed since last update.

VBAでR1C1表示形式とA１表示形式を切り替える方法

Last updated at 2015-05-24Posted at 2015-05-20

vbaで大量のエクセルブックの表示形式をA1形式に統一する必要があったので
その時の備忘録。

Function changeViewStyle(sheetobj As Worksheet)
    If (Application.ReferenceStyle = xlR1C1) Then
        Application.ReferenceStyle = xlA1
    ElseIf (Application.ReferenceStyle = xlA1) Then
        Application.ReferenceStyle = xlR1C1
    End If
End Function

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up