Remove 0 value from specific cells

[JustGWN]

Hello, I followed directions on this issue from an old thread, but I found that the code either deleted my formulas (which I don't want) or it removed all zeros w/ formulas left intact (also don't want). I'm looking to remove zeros only from specific cells and leave others. Thx. If I can add an activecell entry? I tried that already but got an error in the code. New to VBA, not sure what was wrong.

 

[Joe4]

Probably the best way is to use a custom format to hide the zeroes.
See here: Display or hide zero values

I deleted your replies in the other thread, as you should not ask the same question in more than one place on these forums, as per forum rule 12 here: Message Board Rules

 

[JustGWN]

Probably the best way is to use a custom format to hide the zeroes.
See here: Display or hide zero values

I deleted your replies in the other thread, as you should not ask the same question in more than one place on these forums, as per forum rule 12 here: Message Board Rules

Yes, I know but once I posted, the site gave me a message that because it was so old, I should create a new thread. Thx.

 

[JustGWN]

Probably the best way is to use a custom format to hide the zeroes.
See here: Display or hide zero values

I'm looking to apply it to specific cells via VBA. Thx.

 

[Joe4]

I'm looking to apply it to specific cells via VBA. Thx.

Its easy enough to apply that custom format to specific cells via VBA, i.e.

    Range("E13").NumberFormat = "0;-0;;@"

or something like:

    ActiveCell.NumberFormat = "0;-0;;@"

 

[JustGWN]

Its easy enough to apply that custom format to specific cells via VBA, i.e.

    Range("E13").NumberFormat = "0;-0;;@"

or something like:

    ActiveCell.NumberFormat = "0;-0;;@"

Modified to allow for decimals and its perfect! Thx

 

[Joe4]

You are welcome.

Note that you can get code like this by using the Macro Recorder and record yourself doing it manually to some cell (applying the custom format).
The Macro Recorder is a great tool for getting snippets of code! Just record yourself performing the steps manually, and see the code it records.

 

[JustGWN]

You are welcome.

Note that you can get code like this by using the Macro Recorder and record yourself doing it manually to some cell (applying the custom format).
The Macro Recorder is a great tool for getting snippets of code! Just record yourself performing the steps manually, and see the code it records.

I do usually add VBA by doing that, testing just want I need, then adding to other code. But I didn't think of the formatting as you have provided. Thx again.

 

[Joe4]

I do usually add VBA by doing that, testing just want I need, then adding to other code. But I didn't think of the formatting as you have provided. Thx again.

OK.
I just followed the steps in the link from my first reply with the Macro Recorder turned on.