More than 5 years have passed since last update.

Rangeで取得したデータを常に配列型として扱う

Posted at 2013-12-11

    Dim lastRow As Long
    Dim varData As Variant

    ' なんらかの方法でlastRowを取得
    varData = Worksheets("address").Range("B2:B" & lastRow).Value
    
    If Not IsArray(varData) Then
        varData = Array(varData)
    End If

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