Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Modify multiple cells at once using a range reference (like A1
Sub MyMacro()
         ' Insert the text "Hello" in ten cells
         Range("A1:A10").Value = "Hello"
     End Sub