| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill Array from a Range
Why can't I fill my array from the range below? I have ensured that the
range is (8 rows X 3 columns). Dim lngLastRow As Long Dim aryUserInfo(8, 3) As String ' set array equal to username range With Workbooks("QG Add-In.xla").Sheets("Login Data") lngLastRow = .Cells(Rows.Count, "A").End(xlUp).Row Error aryUserInfo = .Range("B2:D" & lngLastRow).Value End With -- Cheers, Ryan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order) | Excel Programming | |||
| Create an Array to fill a Range | Excel Programming | |||
| how do i fill an array? tia | Excel Programming | |||
| fill array | Excel Programming | |||
| fill down array to last available row | Excel Worksheet Functions | |||
Threaded Mode
