Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compile Error (2003 SP2)

    Good morning

    I have the following part of a VBA code

    For Each cel In Range("E6:AI15", "E17:AI26", "E28:AI37", "E39:AI48", "E50:AI59", "E61:AI70", "E72:AI81", "E83:AI92", "E94:AI103", "E105:AI114", "E116:AI125", "E127:AI136").Cells

    But I keep getting a compile error with <font color=blue>Range </font color=blue> highlighted, any ideas please

    Cheers

    Steve
    Attached Images Attached Images
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compile Error (2003 SP2)

    What if you remove all quotes except the outer ones?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compile Error (2003 SP2)

    Thanks Jan

    That did it

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

Posting Permissions

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