Hi all,
I've searched the net and mrexcel.com for this with no luck for my specific (simple) problem. Macro recorder hasn't helped me either. I'm just starting out with VBA...
I have three tables in my active sheet. Table 3 (the one I need solution for) has its headers from G8:J8. That stays fixed. However, the rows change based on the amount of data.
I'd like Table 3 to Resize its rows to the last row of data, so there are not tons of blank Table rows still underneath.
I already spent a while editing this larger macro to get the data how I need it. This row adjustment is the final touch I need.
Thanks,
James
I've searched the net and mrexcel.com for this with no luck for my specific (simple) problem. Macro recorder hasn't helped me either. I'm just starting out with VBA...
I have three tables in my active sheet. Table 3 (the one I need solution for) has its headers from G8:J8. That stays fixed. However, the rows change based on the amount of data.
I'd like Table 3 to Resize its rows to the last row of data, so there are not tons of blank Table rows still underneath.
I already spent a while editing this larger macro to get the data how I need it. This row adjustment is the final touch I need.
Thanks,
James