Forum Discussion

excelnewbie1's avatar
excelnewbie1
Copper Contributor
May 20, 2021

copy paste special values with using VBA

I see you can use VBA to copy the value of a formal. For those who don't know VBA can you do this using a formula. My goal is to use a worksheet template that when I insert a column of data into a ce...
excel
HansVogelaar's avatar
HansVogelaar
MVP
May 20, 2021

excelnewbie1 

Here is a macro:

 

Sub ExtractAmounts()
    Range(Range("A3"), Range("A3").End(xlDown)).TextToColumns _
        Destination:=Range("B3"), _
        Other:=True, OtherChar:="$", _
        FieldInfo:=Array(Array(1, xlSkipColumn), Array(2, xlGeneralFormat))
End Sub

Resources