Macro: Fill Down

[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 EXCEPT when there is only one row of data. When there is only one row, 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!

[mudraker]

try this

Please Login or Register  to view this content.