Copy range down as far as certain value

I need a macro to copy from A4 down until it finds the value 0 and then paste the values into sheet2 F1.

Do you mean like this?

Please Login or Register  to view this content.

Almost. This includes the 0. I want the cell before the 0 is reached. Also, I have formulas in the cells I am copying and only want the values pasted.

Please Login or Register  to view this content.

How would I alter it so that when it finds the first 0 from A4 downwards it copies and paste range D4:Dx where x is the row above where the 0 was found in column A...???

Would it be an offset or?

This should do it? Since you marked solved thought I think you figured it out.

Please Login or Register  to view this content.