Copy/paste of IfError excel fonction return bad data

Hello all

We use a lots of IfError "" in excel to covert div/0

Now I have a macro that copy/paste the Empty cell with an IfError "" fonction, and when paste in an other workbook, well the cell is not really empty, I think it is a nullstring.

So I would like to make a small macro that will select the entire range of data (D503:CT1500) and convert all nullstring in really empty cell so it wont bug the workbook fonction.

So far I have tried this but it didnt work:

Please Login or Register  to view this content.

Thanks all in advance

Chris

Try,

Please Login or Register  to view this content.