Select data without formulas and paste to another tab

[YuriyBaron]

Hi,

I need to copy a table that starts at M6:U6. The table is dynamic so the length changes daily. Sometimes its longer/shorter.

When using the following code:

Please Login or Register  to view this content.

It selects all the data including the formulas at the bottom of the table. Is it possible to not select the empty cells that only include formulas and then copy the table to another tab?

Tab with the table is: "Dump"
Tab where the table needs to be pasted: "Time Database" (first empty cell in Column A)

Thanks.

[jolivanes]

Try

Please Login or Register  to view this content.

Get used to NOT using select or activate. Very seldom required.

[YuriyBaron]

This copied the correct field and pasted it into the correct area; however, it copied only the formulas and the formatting of the cell and not the actual data. I need the exact opposite.
All cells in the table contain formulas that are not visible if there is no data to be displayed. I used "Iferror" to have the cells blank.

After messing with it and using your code, I was able to get this to work:

Please Login or Register  to view this content.

[jolivanes]

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[YuriyBaron]

Yes, both worked.
Thanks.

[jolivanes]

Please Login or Register  to view this content.

in your Post #3 does exactly that what you say you don't want in Post #1

[YuriyBaron]

Yes, I know, your Sub MaybeB() works much better.

[jolivanes]

Thanks for the feedback and good luck