Err when I paste data with formulas as values in data validation cells with Ignore Blank Applied

[drom]

Hi and thanks in advance!

I have a huge table in excel, many rows, many Columns.

I have to fill Say from Col 1 to Col 34 by Macro. NO PROBLEM

Then I use a Formula for some other Columns Say Columns(35, 36, 37 and 38)

Once the formula It's been pasted and calculated I paste just the Values, NO PROBLEM

Why I don't use a Macro, Because I do not like

The Column 35 has a List Data Validation within the Table.

This Data Validation allows Empty cells, so Ignores Blank cells.

My Problem:

When I paste the Data as values and I paste empty values, I get err on the empty cells in this column.


If I go to the Inmediate VBA window and I input
?"XXX" & Activecell.value & "XXX"
I get:
"XXXXXX"

So the cell is actually empty, what am I missing?

If I delete the actually empty cell, the err dissapears.

 

[yky]

If I go to the Inmediate VBA window and I input
?"XXX" & Activecell.value & "XXX"
I get:
"XXXXXX"

So the cell is actually empty, what am I missing?

If I delete the actually empty cell, the err dissapears.

It's better to check with LEN() in case there are non-printable characters.