I'm trying to use Excel to create a Macro to copy a table of data that has a preset column (A:G) size but varying number of rows (R2: RXXX, variable amount of data).
These matrix of data is to be copied into another custom windows database program that will not except empty rows - hence in my Macro code, I am trying to be able to copy the every changing size matrix.
ie. If I have ten lines of data to copy, I can specify the Macro to copy A2:G11 matrix. But if there are twenty lines of data, it has to copy a different size matrix A2:G21.
Is it possible to get excel to report a particular matrix size in some way such that it can be used in a simple Macro?
Bookmarks