mercredi 15 août 2018

Copy and If function

may I know where went wrong? I want copy the cell and with if function checking, then past to another cell

Sub Macro1() ' ' Macro1 Macro

Range("D2:D3").Select

If Selection.Value = "Batch" Then
 Value = "batch"

ElseIf seletion.Value = "individual" Then
Value = """"

End If

 Range("G2").Select
ActiveSheet.Paste

End Sub

Aucun commentaire:

Enregistrer un commentaire