Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Changing multiple cells

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Ireland
    Posts
    107
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just a simple question here. How do i change multiple cells in the one statement or does it have to be done as below:
    Sheets("Sheet1").Range("F4").Value = newValue
    Sheets("Sheet1").Range("F8").Value = newValue
    [Brian]

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    363
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try this:

    application.Union(range("a1"),range("a5")).Value = newvalue
    It's never too late to learn something new.

    Ricky

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •