Quote:
Originally Posted by isasa74
At some point I used a formula to concatenate six cells, now two of them have a currency symbol along with the value (can be either USD or EUR) and I would need the symbol being concatenated as well.
|
Unless the cells contain text, the currency symbols are just cell formatting and are not part of the values themselves. That said, you should be able to retrieve the format if you change the way you're populating the array. For example, instead of:
.Cells(I, 2)
to return the value you might use:
.Cells(I, 2).Text
to return the formatted value.