Code: Concatenate

[abuchan]

I have three columns (9, 10, & 11); text, currency, and text and I am trying to move them from seperate columns on Sheet2 to one column with forward slashes "/" between them on Sheet3. The attached code does this, however I lose the dollar sign and commas. I need help combining them AND maintaining the dollar sign and commas.

Please Login or Register  to view this content.

Thanks.

[Richard Schollar]

You could just use the Text property of the currency (?) column to display the value as it appears in the cell:

Please Login or Register  to view this content.

Richard

[Marcol]

This seems to work

Please Login or Register  to view this content.

Dont know where the commas come in to it

[royUK]

Not sure why you need code to do this,try

Please Login or Register  to view this content.

[Marcol]

In case cell is not formatted.