Ignore empty rows when performing copy and paste

[chriswrcg]

I am using the following code to copy and paste a range of cells from one worksheet to another. The issue is that the cells that are currently blank are being copied as well. The data in the copy range will change so The number of empty rows will always vary. What can I add to the code to copy only the cells with data and ignore the empty rows?

Please Login or Register  to view this content.

It might be possible that excel is viewing the cells as having something in them when in reality they do not. They do contain formulas that populate the cell but show blank when there is nothing to populate them.

[Richard Buttrey]

Hi,

Maybe

Please Login or Register  to view this content.

[kvsrinivasamurthy]

Try this code.

Please Login or Register  to view this content.

[sintek]

Please Login or Register  to view this content.