Just for information, the macro expects a number in column F. If the row is
blank, then it doesn't find one. Thus the error.

I expected no blank rows from the last filled row back up to row 1, so I
didn't put in anything to check for this possibility.

But, glad you achieved your objective.

--
Regards,
Tom Ogilvy

"Screamerz" wrote in message
...
I'd like to thank everyone for helping me out on this macro. I used Tom
O.'s
version, it worked beautifully, but couldn't exit gracefully. It came up
an
error once it hit a row with a blank value in it. I simply hit "End" in
the
dialog box.

David's macro did a good job but didn't do the series fill in column E. It
also errored once it hit the end, just like Tom's.

Anyways, thank you for your help, it was a great time saver, and we were
able to finish the job in time.

Barry (Rcoaster)