The macro that i've written is to concatenate cells with data in, the number
of rows can vary depending on the sort of data I'm working with. The macro
works, it concatenates the cells that i've asked it to, however, it
concatenates the empty cells below the data also, resulting in problems when
i try and sort the data after i have run the macro - it brings empty cells up
to the top. Would be very appreciative if anyone knows what value I can
write in the script so that the macro works on data that is there, no matter
how many rows down it is.