Consulting

Results 1 to 3 of 3

Thread: Trying to set color to a range

  1. 07-19-2019, 08:51 AM #1
    mongoose
    mongoose is offline
    VBAX Regular
    Joined
    Jul 2019
    Posts
    51
    Location

    Trying to set color to a range

    Getting an error on this line of code...is it syntax related?

    'Set cell background color to Red for a range of cells for Jan-Current Month
        Range("E1:P" + .Cells(.Rows.Count, 1).End(xlUp).Row).Interior.Color = RGB(255, 0, 0)
    Reply With Quote Reply With Quote
  2. 07-19-2019, 10:09 AM #2
    p45cal
    p45cal is offline
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,872
    change that + to a &
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
    Reply With Quote Reply With Quote
  3. 07-19-2019, 10:54 AM #3
    mongoose
    mongoose is offline
    VBAX Regular
    Joined
    Jul 2019
    Posts
    51
    Location
    That did it. Thank you!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

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

Forum Rules