Fill Data Series - Problems with only one row of data.

[ashleyhkim]

I currently have a macro so that cell B8 is given a value of 1.
Then it selects the range from B8 to the last cell in that column and does a fill series.

Please Login or Register  to view this content.

This works most of the times. But the number of rows containing data differ with each spreadsheet, and when there is only one row of data, it fills down from B8 all the way down to cell B65536 at the bottom of the excel worsheet.
Is there any way to possibly count the number of rows containing data and then allowing the Fill Series macro to run only if there are more than one rows? I would really greatly appreciate your help. Thanks!

[StephenR]

Try working from the bottom up.

Please Login or Register  to view this content.

[ashleyhkim]

Thanks, StephenR! Works perfectly! :D