Hi MartinW
That works perfectly, you have saved me lots of grief. Thanks a lot

"MartinW" wrote:

Hi Andym,

You can do this with a helper column,
Say your first value is in A2 put this in B2 and drag down
as far as is needed.
=IF(A2="",B1,A2)

If your values start in A1 you will need to insert a blank row first.

HTH
Martin


"Andym" wrote in message
...
Can anyone advise how i can autofill a column each time there is an
occupied
cell down to the next occupied cell and carry on doing this to the end of
the
column? I can obviuosly do it manually but is there a line i can put in a
macro to do this?

Thanks