Fill Down sequence of numbers

Not too good with VBA, but what is it you're looking to do with this that can't be done with a simple formula in Excel?

Anybody have any thoughts?

Please post a sample of what you are trying to accomplish.

Is this what you wanted?

Please Login or Register  to view this content.

Or possibly

Please Login or Register  to view this content.

I have commented out .FillDown and left it as an option
You might need a combination of both to get your result depending on yout data types.

Yes! That is exactly what I want! However, it also auto fills column E (which has a value of 0) with a sequence as well, and I don't want that to be in sequence, but rather to keep that as '0' all the way down. How do I do both?


Attached is a sample spreadsheet.

Yes I did not explain that very well, I was about to edit my post#7.

I'll look at your file and post again, if nobody beats me to it

Don't know what you want series filled and what just to fill down from your sample sheet

However if you split your column ranges to your own requirements, something on these lines

Text will not fill in series Numbers and Dates will

Please Login or Register  to view this content.

Hope this helps

That did it! Thanks Marcol!

Glad to be of help.

If that takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.