Hi,
I have copied a formula across a range of cells in VBA and some of the cells in the range contain an error once the formula is pasted (which is fine) but i need to get rid of that green triangle in the corner of the cell using VBA as the front sheet is an automated dashboard and it looks bad. Can you help please?
Thanks
I have copied a formula across a range of cells in VBA and some of the cells in the range contain an error once the formula is pasted (which is fine) but i need to get rid of that green triangle in the corner of the cell using VBA as the front sheet is an automated dashboard and it looks bad. Can you help please?
Thanks