Recent content by markozzz

Thank you both! I used PHV`s method, but im sure it both works. Rgds, markozz

Hi, I couldnt figure this out.. In this sentence: ...Sheets("Sheet1").Range("G:J"), 4, False) in .Range("G:J") i would like "G" to be a variable. Like .Range("(Var),J").. But that obviously doesnt work. Help please? Rgds, Markozzz

Thanks mike! Its all working now. Rgds, Markz

Whatever, i figuered out myself.. In case anyone wonders; Dim myRow As Long Dim LOCno_hit As String Dim Valve As String 'Definerer aktivt område å jobbe i For myRow = 1 To 10000 'Definerer tagno som string Valve = Cells(myRow, 1) If Cells(myRow, 8).Value = "LOC500" And Left(Valve, 1) = "W"...

Hi, I understand that you are confused, and that IF-statement isn`t really good.. In general, whats a bit special is that if one value in H-column matches e.g "LOC500" in sheet1, then i want to lookup a value in an other column in that same row. but i cant lookup the value im looking for in...

Hi, i have a rather easy problem, but i cant seem to work it out correctly.. I have a looong IF-statement, which i have to convert to an SelectCase statement. The statement should apply to all rows in a distinct column (H), or at least 10000 rows The IF-statement i originally made, was like...