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