I would appreciate help with a macro to sort data in a small table.
Say the table is in range A1:F15
Problem:
Sometimes not all rows contain data. The last one, two or more (up to 6 or 7)rows may be empty. When Excel sorts the whole table it places empty rows on top and it leaves corresponding gaps in the chart associated with the table!
Instead of writing the range A1:F15 in the macro, what line of code can I use so that Excel selects only the rows that contain data?
The empty rows are always the ones at the bottom of the table. And, as I say, it may be anywhere between the last one and the last seven rows that will be empty.
I would appreciate any help. I am not a programmer...as if you couldn't tell!
Thanks
Say the table is in range A1:F15
Problem:
Sometimes not all rows contain data. The last one, two or more (up to 6 or 7)rows may be empty. When Excel sorts the whole table it places empty rows on top and it leaves corresponding gaps in the chart associated with the table!
Instead of writing the range A1:F15 in the macro, what line of code can I use so that Excel selects only the rows that contain data?
The empty rows are always the ones at the bottom of the table. And, as I say, it may be anywhere between the last one and the last seven rows that will be empty.
I would appreciate any help. I am not a programmer...as if you couldn't tell!
Thanks