Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. If the value of the active cell is too big, change it
Sub MyMacro()
         If ActiveCell.Value > 100 Then
             ActiveCell.Value = 100
         End If
     End Sub