My questions are in code comments.
I created a 10x10 table using randarray() and assigned integer data type in Excel; also tried copy pasting as values in A13. Don't know if VBA picks up functions differently to raw data.Please Login or Register to view this content.
However, when I assign myArray() As Long/Integer, it doesn't seem to work.
Lastly, for a 10x10 table, why won't Dim myArray(1 to 10, 1 to 10) work?
Bookmarks