Results 1 to 5 of 5

Case without select case error

Threaded View

Tano Case without select case error 07-25-2007, 09:40 AM
SOS Hi Tano, You missed out... 07-25-2007, 10:12 AM
Tano What a stupid mistake. Thanks... 07-25-2007, 10:16 AM
SOS Sorry, Tano, don't know the... 07-25-2007, 10:26 AM
Tano Yeah, that's how I found the... 07-25-2007, 10:27 AM
  1. #1
    Registered User
    Join Date
    07-25-2007
    Posts
    3

    Case without select case error

    I need some help on my code. It gives me a case without select case error. Can anybody give me some hints on what is wrong?

    For i = 11 To 51
    r = Range("R" & i).Value
    w = Range("M" & i).Value
    Select Case r
    Case Is > w * 1.15
    Range("R" & i).Activate
    With Selection.Interior
    .ColorIndex = 3
    .Pattern = xlSolid
    .PatternColorIndex = xlAutomatic
    Case Is < w * 0.85
    Range("R" & i).Activate
    With Selection.Interior
    .ColorIndex = 4
    .Pattern = xlSolid
    .PatternColorIndex = xlAutomatic
    Case Else
    Range("R" & i).Activate
    With Selection.Interior
    .ColorIndex = 1
    .Pattern = xlSolid
    .PatternColorIndex = xlAutomatic
    End Select
    Next i
    i is an integer, r and w are doubles
    Last edited by Tano; 07-25-2007 at 09:45 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1