How to remove the " " blank spaces which are added with formula in a Range with MACRO
Some formulas in order to show blank cells add " " blank spaces but now I want to remove such blank spaces
I cannot change the code of adding it in the first place as that would mean changing the entire
design however I want to just get rid of some of the blank spaces in the cells as when I am doing a CountA on this column I
do get them in the count.
I have tried using the
Range("A2:A200").Value = ""
But in vain for some strange reasons the blank spaces just dont go...