Special cell formatting problem!

[mardo]

Hi!

I have this quite annoying problem whít copy-paste special.

I've made a macro that copies range of cells to another worksheet.
Everything goes fine, but I need to add ' ', to every cell where I
paste cells. Cells containing only numbers are fine, with custom cell
formatting. I just can't get those characters added to cells containing
only text. Text and numbers should go after first ' .

I would really appreciate any help and I have this feeling its really
easy trick and I'm just looking an answer from wrong place.

Heres an example to clear out what I mean:

copied cells After paste, it should look like this...
12345 '12345', | '00015', | 'Ice-Cream', | 'each', |
'100', |
00015
Ice-Cream
each
100
...but text cells are just ... | Ice-Cream
| each | ... ' ... ', are missing!!



Thanks already!!

Mardo

 

[mardo]

Ooops... Of course it was ment to look like this:


copied cells:
| 12345 |
| 00015 |
| Ice-Cream |
| each |
| 100 |

After paste, it should look like this...
|12345', | '00015', | 'Ice-Cream', | 'each', | '100', |

but text cells are just | Ice-Cream | each | ' ... ', are missing!!

Sorry,
Mardo

 

[Sandy]

If your doing this through VBA code you might have better luck posting
this question into microsoft.public.excel.programming and post your
code along with your question. Then everyone will be able to better
understand what you are trying to do....if you are just doing a custom
format then try using '@' as a custom number format

Sandy