Fill Series Question

[pujo]

Hey Gang,
I am wanting to fill colum A with a series of numbers, say 1,2,3......and so on. But I want to skip a few cells while doing this. Is there a way I can skip a few cells and leave them blank, but continue with the series bellow the skipped cell?

Is this possible?
Thanksin advance,
PuJo

 

[pujo]

Any way I can skip a cell while dragging to fill series?

 

[pujo]

Maybe i can explain a little bit better.

I have a worksheet, in column "A" I just want the cells numbered from 001 in munerical order until the very last row.
But, I want to skip the blank cells in column "A", and if I insert a row, I would like to run the macro again to reassign the numbers correctly.

Is there any possible way to do this?

Thanks,
Pujo