This was solved in a previous thread "s there a way to replace specific letters in a range of cells with symbols?".
However, i'm having some trouble getting the ranges correct. I would like to have three columns, one for each of the three cards. I've been playing around with the ranges in VBA but nothing seems to work.
Heres the vba code that gets it correct for one column:
This code resulted in this:
I would like to split the cards like this:
As you can see, i only get colours on the first column. Would love to get some feedback on this, and if possible a little explanation so that i can understand this. Pretty frustrating when nothing seems to work haha.
Cheers!
However, i'm having some trouble getting the ranges correct. I would like to have three columns, one for each of the three cards. I've been playing around with the ranges in VBA but nothing seems to work.
Heres the vba code that gets it correct for one column:
This code resulted in this:
I would like to split the cards like this:
As you can see, i only get colours on the first column. Would love to get some feedback on this, and if possible a little explanation so that i can understand this. Pretty frustrating when nothing seems to work haha.
Cheers!