Help in storing values to an array

Hi all, I'm trying to learn more stuff about macro excel by trying how to store values into an array. I tried this website and decided to copy and paste this chunk of code to see how he/she stored his values into an array:

Please Login or Register  to view this content.

However he has this "Type mismatch error" at this code " dCellValues(iRow) = Cells(iRow, 1).Value"

I have no idea why he got this error, I tried to replace the code with "Range("A", iRow).Value" but it still yields the same error.

Please help, I tried to look for another source to learn array stuff in macro excel, but couldn't find any simple codes that I can understand easily. You could also help me by giving me some nice links for tutorials:D Thank you xD

hi, crisshinn, error "Type mismatch error" usually means that you trying figuratively to sum 2 apples and 1 litre of water. In your case your array can hold only data of Double data type:

Please Login or Register  to view this content.

and you are trying to force it to hold something else (String data or Integer etc.). Check value of Cells(iRow, 1)