1. A

    VBA another way to write or statement

    Good morning, I am pretty new to VBA. Just wondering is there a shorter way to write multiple or's in VBA. Thanks in advance If (gradelevel = 1 Or gradelevel = 2 Or gradelevel = 3 Or gradelevel = 4 Or gradelevel = 5 Or gradelevel = 6) Then
  2. S

    VBA Rewriting OR's

    I am not great at VBA but I am looking for another way to write many OR's . Can someone please guide me. Thanks in advance! if cells(i,1)=10 or cells(i,1)=21 or cells(i,1)=37 or cells(i,1)=39 or cells(i,1)=47 or cells(i,1)=52 or cells(i,1)=63 or cells(i,1)=64 or cells(i,1)=67 or cells(i,1)=68...
  3. Weeble

    VBA IF with to many Or's

    If (P10Text.Value = "*" Or P20Text.Value = "*" Or P30Text.Value = "*" Or P31Text.Value = "*" Or PLText.Value = "*") Then Worksheets("PlockSnitt").Activate Could anyone give me a suggestion on how to write this statement in a better way? Does not work that great for me. Basicly I need if...
  4. J

    Mulitple OR's using IF's?

    I have a problem that is driving me crazy. I have data coming to a cell, it will be between 0.00% and 0.50% I want to have a weighted percentage using this data. So if Cell E39 is 0.00% I want E40 to read 0% but if it E39 is 0.01% to 0.10% I want it to read (-10%) 0.011% to 0.20% reads...
  5. P

    Ifs and Ors Please help

    Hi, I am having a problem with writing the ifs and ors. My spreadsheet is basically the first sheet with different positions within a company and beside their names are three columns of rates. <TABLE style="WIDTH: 240pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=320 border=0...

Some videos you may like

This Week's Hot Topics