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