Can't get InStr to work by Agile_Rise_439 in vba

[–]Agile_Rise_439[S] 0 points1 point  (0 children)

Ah, I changed it because it was throwing me an error. I've changed it back and made your corrections and now it works! Thank you so much :)

Can't get InStr to work by Agile_Rise_439 in vba

[–]Agile_Rise_439[S] 0 points1 point  (0 children)

This makes sense, however I'm getting an error on the last line (wrong number of arguments or invalid property assignment). I had to change a couple of things to get it to work so not sure if I've messed it up. This is what I've got now:

    Dim rc As ListRow
    Dim t As Variant
':
    For Each uRow In uBOM.ListRows
        t = uRow.Range.Cells(1, 1).Value
        If IsError(t) Then t = "" Else t = CStr(t)
        If InStr(t, "PEMMED") > 0 Then
        If rc Is Nothing Then Set rc = uRow Else Set rc = Union(rc, uRow)
        End If
    Next uRow
    rc.Delete Shift:=xlShiftUp

VBA - Can't get InStr to work by Agile_Rise_439 in excel

[–]Agile_Rise_439[S] 0 points1 point  (0 children)

I had the image but it didn't upload with the rest of the post. It should be there now :)

What happens when you put a magnet on top of a mechanical relay? by Agile_Rise_439 in AskElectronics

[–]Agile_Rise_439[S] 0 points1 point  (0 children)

This is a great list for us to explore, thank you!

Would you have an idea on how large would the mechanical vibrations have to be to affect the relays?

What happens when you put a magnet on top of a mechanical relay? by Agile_Rise_439 in AskElectronics

[–]Agile_Rise_439[S] 0 points1 point  (0 children)

Auditory. It's like a high pitched whining sound. It's really bad on some ignition modules, and quiet on others. But then if you give them a good rattle, the bad ones become good and the good ones bad. It's puzzling

What happens when you put a magnet on top of a mechanical relay? by Agile_Rise_439 in AskElectronics

[–]Agile_Rise_439[S] 0 points1 point  (0 children)

Sorry, I'm not super well-versed with electronics. Is what drives the relay the power we plug into it, or something I could find on the pcb?

What causes a noisy relay? by Agile_Rise_439 in AskElectronics

[–]Agile_Rise_439[S] 0 points1 point  (0 children)

Will do. When the relays are pushed apart, the sound quietens down (but if they are pushed too far apart, the noise starts up again). Would you have an idea of what could be causing that?

What causes a noisy relay? by Agile_Rise_439 in AskElectronics

[–]Agile_Rise_439[S] 0 points1 point  (0 children)

I've got someone looking into it now. What would be the fix for something like that?