array Reading Worksheets worksheet Vba Read Worksheet Into Array 16 May, 2021 Public Sub TestLoopArray declare the array Dim rnArray As Variant Declare the integer to store the number of rows Dim …