I am designing a spreadsheet using macros in which I want to copy a range of cells from one sheet and paste to another. I am able to do that part but what I want to do is to find the way that the macro recognizes the first set of cells is already with data then should paste to the next one. I will appreciate any suggestion.