Forum Discussion
Including number format paste special in the Macro
Hi! Is it possible to paste values formatted as number? Somehow after running the macro certain values in the sheets are "number stored as text", resulting in #N/A for lookups in the following steps/...
Use Data -> Text to Columns can solve this issue.
You can find more infomation in Excel Help: Move pointer to a cell with green mark -> An exclamation menu pop out -> click "Help on this error"
Action could be recorded:
Selection.TextToColumns Destination:=Range("I1"), _
DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, _
Tab:=True, _
Semicolon:=False, _
Comma:=False, _
Space:=False, _
Other:=False, _
FieldInfo:=Array(1, 1), TrailingMinusNumbers:=True
You can find more infomation in Excel Help: Move pointer to a cell with green mark -> An exclamation menu pop out -> click "Help on this error"
Action could be recorded:
Selection.TextToColumns Destination:=Range("I1"), _
DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, _
Tab:=True, _
Semicolon:=False, _
Comma:=False, _
Space:=False, _
Other:=False, _
FieldInfo:=Array(1, 1), TrailingMinusNumbers:=True