Copy and paste row if a cell has a value

[mattman123]

Hello,

I am using the following code to copy an entire row when that row has data in column Y, and then paste that row into a different worksheet.

Please Login or Register  to view this content.

Because the data in column Y is generated via a formula, the first thing I'm doing is copying and pasting special as values.

Please Login or Register  to view this content.

Does anyone know why calling this second macro would cause the first macro to return every row (even those without data in column Y)?

THANK YOU!

[AB33]

Mattman,
The first code pastes VALUES ONLY, so why do you to paste them again?
If you are calling the first macro from the second macro, the first amro has to complete running until the sub ends, unless otherwise, you instructed to stop somewhere.

[mattman123]

The macro doesn't seem to work if the cells in column Y are pulling data from other cells (gets an error); therefore, I ran the copy and paste special macro BEFORE running the one you wrote.

But when I run the paste special macro and then the one you wrote, it copies and pastes all of the rows, not just ones with values in column Y.

[tuongtu3]

Try this

Please Login or Register  to view this content.

[tuongtu3]

Try this

Please Login or Register  to view this content.

[tuongtu3]

Try This

Please Login or Register  to view this content.

[AB33]

The macro doesn't seem to work if the cells in column Y are pulling data from other cells (gets an error);

Regardless of the value of column Y, my code converts the formulae in to values if that cell is empty.
o you want to copy all cells(Including the blank), and convert them in to values?