VBA: Copying cells from an excel spreadsheet
Posted on 2000-05-11
Hi, i need to know how to copy the data in cells as text and not with the extra formatting it usually copies as well.
Basically, what I need to do is the same as copying a range of cells and the selecting the paste special, and pasting as text. Unfortunately, the other app, I am pasting into, does not have the paste special option....So I want to do something like a Copy special - Text only. I would need this command to replace the standard <Ctrl-C> in my excel spreadsheet as well.