Copy only cells with data in

[MOONDRIFT47]

Hi,

I have the following code for copying two sheets in one workbook to another workbook. However, the subsequent running of the program always pastes to where the last time had even if there were blank cells and I'm asking it to paste values only.

E.G. the first time run the range is copied, then pasted and goes to row 50, however there is only data up to row 25. Next time same macro is run it starts pasting at row 51. IS there a modification someone can suggest that means only populated cells are copied or pasted rather than copying a fixed range?

Please Login or Register  to view this content.

[MikeVol]

Hello. Without an example file... Try the following code, maybe I guessed right. Not sure but...

Please Login or Register  to view this content.

[MOONDRIFT47]

Hi,

Thank you for the reply. It still copies a range on the L and G sheet regardless of data in there or not so I end up with same problem, the next time the macro is run it pastes right at the end of the previous area of pasted data even though the cells are all blank. i think the code was a little mixed up as both results went on the g sheet. i appreciate the help.