Adding additional IF condition

Hi Guys

I have a code that searches in a column for a certain value, if it finds it, it copies this value to a range adjacent to it.

Please Login or Register  to view this content.

However, if the cell where the code is supposed to find a new value is blank it makes the range blank.
But in that case, I wan't it to leave the range cells with their original value.

I have attached a sample workbook that clarifies the problem.

Best regards
Danny

That is the exact same code.

So that didn't help very much..

/Danny

Please Login or Register  to view this content.

Thank you very much for your reply.

However the code still deletes the entries in the "Plate" column if the value in the column "Value" is empty.
I need the code to leave the value alone except when the there is a different value.

Br/Danny

Danny,
There was a syntax error. If the condition was false, this line still applies
.Value = s

Please Login or Register  to view this content.

Thanks for your help.

But now the code only writes in one cell in the range 28-03-2014 13-30-58.png

I need it to populate the whole "plate" range.

Br/Danny

Danny,
I have not set up the code-only corrected it.
I do not know why you are using a nested loop to do this task. A simple find function will do the job.
Is this the only condition?

Please Login or Register  to view this content.

Before I write a different code

"And also, the number of tables within each worksheet is not always the same. So I just made the loop to step through all the tables".

is the same as looking at each cell

Please Login or Register  to view this content.

But the find function is faster and does not require testing it for blank cells, but the choice is yours