ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will do that nicely.

Vaya con Dios,
Chuck, CABGx3



"flecky" wrote:

I've looked at some of the other reponses, but I'm an absolute beginner,
because I haven't done macros for many years now.
All I'm trying to do is copy a cell down a column until it hits the next
value, then loop. There are irregular rows between each value.
The data might look like this:
50000
(I want the macro to insert 50000 here)
600023.4
(I want the macro to insert 600023.4
here)
(I want the macro to insert 600023.4
here)
945665