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.