Copy Data Macro - Autoadjust matrix size?

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?