hi,
I am an absolute novice so my question might sound very elementary.
What i need to do is very simple.Just append a ' in front value of each of the cells after copying these cells froma different sheet.
I tried to do it the other way round.First have a ' in each of the cells and then copy.
But thats overwriting the '.Is there a way to append the ' to each of the cells after copying.I tried string append but it is saying type mismatch.
Any suggestions would be appreciated.
Thanks
Mridz
I am an absolute novice so my question might sound very elementary.
What i need to do is very simple.Just append a ' in front value of each of the cells after copying these cells froma different sheet.
I tried to do it the other way round.First have a ' in each of the cells and then copy.
But thats overwriting the '.Is there a way to append the ' to each of the cells after copying.I tried string append but it is saying type mismatch.
Any suggestions would be appreciated.
Thanks
Mridz