Hi everyone,
In a VB macro I am running a need to add code that finds the number of rows and columns in a sheet that contains data.
For example, lets say a particular sheet values in cells A1, A2, A7, and D5.
I would like to read in that there are 7 rows being used (because of cell A7), and 4 columns (because of cell D5).
Because there could be gaps between rows and columns, I can't figure out a way to get this data without checking all columns.
In a VB macro I am running a need to add code that finds the number of rows and columns in a sheet that contains data.
For example, lets say a particular sheet values in cells A1, A2, A7, and D5.
I would like to read in that there are 7 rows being used (because of cell A7), and 4 columns (because of cell D5).
Because there could be gaps between rows and columns, I can't figure out a way to get this data without checking all columns.