Results 1 to 15 of 15

Thread: Solved: Click to color

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 10-26-2011, 06:02 AM #11
    Sorin Sion
    Sorin Sion is offline
    VBAX Regular
    Joined
    Oct 2011
    Posts
    11
    Location
    Replace 
    If i < 11 Then Exit Sub
    with 
    If Asc(Left(Range("A" & i) & "0", 1)) < 65 Then Exit Sub
    This is based on the asumption that your title column is A and always the titles start with a number.
    Last edited by Aussiebear; 03-20-2023 at 04:11 AM. Reason: Adjusted code tags
    Reply With Quote Reply With Quote
« Previous Thread | Next 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