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?

Hi heatwave
one possible way

Please Login or Register  to view this content.

No problem

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save