change cell values of named dynamic range in transfer

Sorry I cannot post the workbook at this time.

I have several sheets, among them are a "Data" sheet and a "List Report" sheet. Initiated by command button on a userform, I use the following code to transfer certain named ranged from the data sheet to the List Report, for example:

Please Login or Register  to view this content.

The ranges that the data are transferred to are also named (dynamic) ranges as well, e.g., "ListRprtRA1" and "ListRprtRA2".

So my question: Is there a method to change the value of each cell in the new range based on it's value?

For example, if the any cell in the range was a "1," I want the cell to appear blank. I can do this through condition formatting (rule: if cell = 1, format fill and font color = white). But if any cell in the range is "2," I would like to change it to another character or value, for example, "Yes" or perhaps a checkmark changing the font type to Wingdings 2.

I've been experimenting with applying some Select/Case code, but am not getting too far.

-HeyInKy

I found my answer...

Please Login or Register  to view this content.

But if anyone would know... I'm using 2 quotations marks to mark all the 1's as blank ("")... is there a better way?