Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Nisha Gor   on Nov 16 In MS Office Category.

  
Question Answered By: Kellie Bishop   on Nov 16

I think the problem  arises from trying to cut and pasteSpecial rather
than copy and paste  special. If you try to cut and pasteSpecial in the
spreadsheet manually you'll find it doesn't offer the option to
PasteSpecial when you've cut rather than copied.

I think the quick answer is to go back and delete the copied cells
after PasteSpecial, but since that operation changes the selection
you'd have to reselct them..

So since you're just copying values how about:

Range(olR2, olR2.Offset(Selection.Rows.Count - 1, _
Selection.Columns.Count - 1)) = Selection.Value
Selection.Clear

This leaves the selected cells as the cleared cells on the sheet
copied from.

Share: 

 

This Question has 7 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on excel 2000 - Wierd Paste Problem Or get search suggestion and latest updates.


Tagged: