Pasting into cell or comment

  • Thread starter Thread starter Steve Walton
  • Start date Start date
S

Steve Walton

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 (e-mail address removed)
 
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
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 (e-mail address removed)
Click to expand...

Steve
 
Back
Top