GeneralShamu
Board Regular
- Joined
- Jul 6, 2007
- Messages
- 127
I have two arrays, a and b. If the row in a is not in b, I want to paste the row in a onto a sheet in the workbook that has the macro to open this data file.
I have the comparison down, I am unsure how to extract an entire row out of a 2d array:
a(i, ???)
and then how to I safely refer to the other workbook and the sheet where I want to past this row.
Rather then pasting it after each iteration, I could create a new array called 'mismatch' but I do not know how many rows it would need to have...I only know the number of columns.
Any advise on any of this?
I have the comparison down, I am unsure how to extract an entire row out of a 2d array:
a(i, ???)
and then how to I safely refer to the other workbook and the sheet where I want to past this row.
Rather then pasting it after each iteration, I could create a new array called 'mismatch' but I do not know how many rows it would need to have...I only know the number of columns.
Any advise on any of this?
