Counting number of specific number of xxx in each cell?

[blitz]

Hello all, I had been looking online to find a solution to my problem and was lucky enough to stumble on this board. I had 2 questions someone on here can hopefully solve.

When working with a group of cells (say 10x10) with a number in each cell, what is the easiest way to count the number of 3’s for each cell (ex: 23253.213 would be 3)?

Secondly, how do I change each 3 to an 8 one at a time for a cell, like change3once = 28253.213, change3twice = 28258.213, etc?

Thank you in advance

[mrice]

Your first question can be solved with

Please Login or Register  to view this content.

[blitz]

Your first question can be solved with

Please Login or Register  to view this content.

Martin; Thanks for your quick response. I see it works for an excel cell, but I am unable to get it to work in Visual Basic (editing my macro). Is there something different I need to do so it will work there?

[blitz]

Martin; Thanks for your quick response. I see it works for an excel cell, but I am unable to get it to work in Visual Basic (editing my macro). Is there something different I need to do so it will work there?

Finally figured out for VBA code it would be

Please Login or Register  to view this content.

Now to figure out the other item

[blitz]

BUMB: Still unable to figure this out

Secondly, how do I change each 3 to an 8 one at a time for a cell, like change3once = 28253.213, change3twice = 28258.213, etc?

[arthurbr]

Please use code tags when editing VBA Thx

[mrice]

Try

Please Login or Register  to view this content.