I recently posted a question regarding why I could not use the fill down function on excel whilst autofilter is on. I have discovered that one of the problems is because I import data from access into excel as if I do this when I import data from excel to excel it works fine. I tried instead recording a macro whereby instead of using filldown i simply dragged the cell down. I am dragging text/numbers and also formulas down. When I run the macro it runs fine filling in the first cell but does not replicate the dragdown of the cell. I need to do this as each time I refresh excel and it imports the data from access it wipes all the previous days work and I have to start again. Does anyone know why this happens? I hope this makes sense. Thanks in advance.