Help: create an array from a range

  • If I have a range of cells say A1:D5 and I wanted in VBA to put them into an array, how do I do it?

    the rows and column need to be dynamic so for rows I will use something like

    LR = (rows.count, "A" ).End(xlup).row
    LC = cells(row, columns.count).end(xltoleft).column

    so now i have the range how do i get the contents into an array?


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!