locked
Excel VBA Copy and Paste operation is resulting in "Number Stored as Text" RRS feed

  • Question

  • I am copying a range of numbers but it is landing where it is pasted as "Number Stored as Text" How do I fix this? Here is the code:

            WSD.Select
            ActiveSheet.Range(WSD.Cells(2, "BG"), WSD.Cells(wsDATA_FinalRow, "BG")).Resize.SpecialCells(xlCellTypeVisible).Select
            Selection.Copy
            Me.Select
            Range("H4").Select
            Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
                :=False, Transpose:=False

    Friday, September 13, 2013 7:16 PM

Answers

  • Insert this before the Pastespecial line

    Selection.PasteSpecial Paste:=xlPasteFormats
    Friday, September 13, 2013 7:39 PM