Macro to insert a rage of cells deletes previous content if range is blank

Hi All, I have a macro in a rostering worksheet which copies overtime details in a range of data,("E8:H22") to another area of a worksheet ("Q100"), then adds the date from ("C6"), deletes blank rows and copies cells with data and inserts it at ("P8:T8"), this works fine if there is content in the cells however if there is nothing to insert it deletes previous content. The way I am doing this is probably taking the long way around, ideally I would like to be able to copy the details directly under ("P8:T8") with date, but I would be happy to know how to have the macro stop copying to ("P8:T8") if there is no content and move on. Thanks in advance, Ed

Please Login or Register  to view this content.

Hi All here is the sample file: Returns.xls

see your other post

Hi folks, sorry for the duplication and confusion I had difficulty attaching my sample file. In the interim I came up with a solution of my own which works (and I understand), I will study your suggestions. I appreciate all your assistance. Thanks very much, Ed.

Please Login or Register  to view this content.