Morning all, I have taken the following macro and have tried to make it work for my spreadsheet whilst it doesn't cause an error it does however delete some of the data and I can't understand why as there doesn't appear to be a pattern to the data it clears. Any help on this would be...