I have a macro to subtotal a set of data. This data will always be different amount of lines. I can set the macro to subtotal only current range. If I try to include all lines so that I account for when the lines of data increase, it will not allow the first line to be included. Any ideas?
i just got it from selecting the range. If i use the current range, everything is fine, but it is when i expand the range beyond the current data to accomadate for future expansion is where i have the problem.
i meant do you use something like this in ur macro
provided that your first cell in data range is A1, these codes always select all rows for you when you run the macro even if you have 2 rows or 2000 rows in your data range as long as there is no blank row(s) separate(s) the data range.