K
katem
Hi,
I've been working on some code, which seems to have stopped working
for reasons which are beyond me. I'm trying to read a range from the
worksheet into an array using the code:-
interpArray = Worksheets(sheetName(j)).Range(Cells(row1, col1),
Cells(row2, col2)).Value
This is pulling up a Run-time Error 1004 "Application-defined or
object-defined error". If I hard code in the array i.e.
interpArray = Worksheets(sheetName(j)).Range(Cells("a622").Value
then it works fine, but I need to be able to move down the sheet as
the macro loops through, as I need a different range to be read with
each loop of the array.
Can anyone help me work out how to fix this?
Thanks in advance!
Kate
I've been working on some code, which seems to have stopped working
for reasons which are beyond me. I'm trying to read a range from the
worksheet into an array using the code:-
interpArray = Worksheets(sheetName(j)).Range(Cells(row1, col1),
Cells(row2, col2)).Value
This is pulling up a Run-time Error 1004 "Application-defined or
object-defined error". If I hard code in the array i.e.
interpArray = Worksheets(sheetName(j)).Range(Cells("a622").Value
then it works fine, but I need to be able to move down the sheet as
the macro loops through, as I need a different range to be read with
each loop of the array.
Can anyone help me work out how to fix this?
Thanks in advance!
Kate