Board index » Excel » Pasting into cell or comment

Excel19
Excuse me jumping straight in - I lurked and posted a long while back

but have been absent for a while



I want to be able to paste the clipboard in TEXT form into the current

cell

I seem to recall that if I just use Selection.Paste it may alter more

then just the current cell

In a similar manner to Inserting Text file



On a similar theme, I have some macros that create / update a comment

how can I paste into a new comment from the clipboard ?



Cheers

Steve


-

Steve;



I might have understood you wrong but....

Can't you just choose Paste Special and select one from a whole range of

options.

Like only values or formats etc.



Also, try to paste the whole text in the formulabar rather then a cell.



Mark.



More Excel ? www.rosenkrantz.nl or contact@rosenkrantz.nl



--------------------------------------------------------------------



"Steve Walton" <sj_walton@hotmail.com>wrote in message



-

Cheers, yes pasting into the formulbar keeps the text in 1 cell.



of course I forgot to put the main ingredient in the original

question.



namely, how do I do this paste from within a macro.



Steve

On Wed, 21 Jan 2004 11:03:24 +0100, "Mark Rosenkrantz"

<mail@rosenkrantz.nl>wrote:



Steve

-