Consulting

Results 1 to 3 of 3

Thread: Solved: Paint next three columns

  1. #1

    Solved: Paint next three columns

    I have error in this program. Please help to know:-

    [VBA]
    Sub test()
    clm = 27
    topaintrows = 29
    Sheets(1).Range(Cells(2, clm + 1)).Resize(topaintrows, 3).Interior.ColorIndex = 45
    End Sub
    [/VBA]

  2. #2
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,778
    This should fix the syntax error.
    [VBA]Sheets(1).Cells(2, clm + 1).Resize(topaintrows, 3).Interior.ColorIndex = 45 [/VBA]

  3. #3
    Thanks, It solved this problem.

Posting Permissions

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