I have a worksheet that imports data from a text file which vary's in size each time from 100 to 1000 rows. I want to subtotal only rows with data. The current macro I use has a set range up to 1000 rows which creates the grand total at the bottom of the page and requires deletion of the blank rows.
Is there a way for VBA to check for non-blank rows instead of the pre-defined range and set the sub-total function to only calc those rows?
Thanks for any help on this.