Hi,

I am using a macro to turn a table into a text string. Example:

A 1 4
B 2
C 1

Into A B B C A A A. I am then using a conditional format to colour the
cells according to the letter inside.

However the above table is the output from another worksheet, which the only
automatic way I can generate is by =if(cell0;cell;€�€�) so that I do not have
zeros in the table. However the macro does not like cells with the IF
formula and no number. So for example in the above table if in the first
column against B I have the IF formula the macro will not work, the cell must
either have a number or be completely empty. The only way it works is if I
go through by hand and delete the formula from the empty cells then use the
macro.

Can I use a function or macro to do this delete operation for me? The
tables are quite big and will get changed quite often so the hand delete is
time consuming.

Thanks