How to remove the " " blank spaces which are added with formula in a Range with MACRO

[e4excel]

How to remove the " " blank spaces which are added with formula in a Range with MACRO

Dear Forum,

Some formulas in order to show blank cells add " " blank spaces but now I want to remove such blank spaces with Macro..

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

Please Login or Register  to view this content.

But in vain for some strange reasons the blank spaces just dont go...

Warm Regards
e4excel

[tlafferty]

By blank spaces, do you mean empty cells? if so,

Please Login or Register  to view this content.

will delete the entire row...

[BigBas]

The code you provided should clear blank spaces:

Please Login or Register  to view this content.

If it doesn't work, post a sample copy of your workbook and we will take a look.

[gjlindn]

Hi e4excel. Are you sure the space isn't in the formatting of the cell? Example custom format is _ @

[Mordred]

Hi e4excel, I have added code tags to your first post. I realize that you only had two lines of code so you might have thought "no big deal" but please remember to use them whenever you post code.

[e4excel]

The code you provided should clear blank spaces:

Please Login or Register  to view this content.

If it doesn't work, post a sample copy of your workbook and we will take a look.

Thanks everyone...for all your suggestions I think the clearcontents does work I was making a mistake..

Warm regards
e4excel

[e4excel]

Hi e4excel, I have added code tags to your first post. I realize that you only had two lines of code so you might have thought "no big deal" but please remember to use them whenever you post code.

Sincere apologies...

No it just genuinely skipped out of my mind...