How to use PasteSpecial to paste numbers as numbers (not text) RRS feed

  • Question

  • I am using the following PasteSpecial statement to copy some numbers, but the end up in the destination where they are copied as text. How can this be =edited to paste as numbers (not text):

    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False

    Friday, September 27, 2013 12:25 PM


  • Try using xlPasteValuesAndNumberFormats instead of xlPasteValues.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Friday, September 27, 2013 1:48 PM