On Apr 16, 5:10 pm, Black country boy
wrote:
I have a macro that sorts data into the correct order, then I manually copy
and paste into a different application. I would like to write code into the
macro that copies the data after sorting, but the length of the data list is
variable, i.e. sometimes it could be spread from A1 to A52, sometimes A1 to
A105. Each time can give a different length, (but always in column A only).
Also, some of the cells are blank, but must be copied as blank.
Thanks.

Hi, Black Country Boy:

Would you please give me an example telling me what you need? I am not
sure whether I can solve your problem.

Thanks,