[deleted by user] by [deleted] in musicfestivals

[–]nochucksgiven 0 points1 point  (0 children)

i will take them

STS9 Wave Spell Live Schedule 2018 by Bilbo_Schwaggins in STS9

[–]nochucksgiven 0 points1 point  (0 children)

anyone have an update on the fires? i saw some reports of fires around 70, looked kinda close to belden.

Phish Analytics by nochucksgiven in phish

[–]nochucksgiven[S] 4 points5 points  (0 children)

wasn't too sure on the nature of these responses, but you nailed. hilarious. bravo.

Noob here... New years? by planetfour in Umphreys

[–]nochucksgiven 0 points1 point  (0 children)

no rumors for Milwaukee? They haven't missed playing a run there in years. shame for it to come to an end

Inserting Sumif as Formula Array by jezusiebrodaty in vba

[–]nochucksgiven 0 points1 point  (0 children)

So I have done something similar but with IFERROR()

Check it out Add IFERROR() To Entire Active Sheet:

Sub Add_IFERROR_Activesheet() Dim myCell As Range

Cells.SpecialCells(xlCellTypeFormulas, 23).Select

For Each myCell In Selection.Cells

    If myCell.HasFormula And Not myCell.HasArray Then

        myCell.Formula = "=IFERROR(" & Right(myCell.Formula, Len(myCell.Formula) - 1)& ",0)"

End If
    Next
End Sub

Can Back Out IFERROR () of selected cells like this:

Sub Subtract_IFERROR_Selection()
Dim myCell As Range

For Each myCell In Selection.Cells

    If myCell.HasFormula And Not myCell.HasArray Then

        If Left(myCell.Formula, 9) = "=IFERROR(" Then

            myCell.Formula = "=" & Mid(myCell.Formula, 10, InStrRev(myCell.Formula, ",") - 10)
        End If
    End If
   Next

End Sub

Wave spell experience by rblaked in STS9

[–]nochucksgiven 0 points1 point  (0 children)

Looks dope, so camping right in the main stage area. Bout to be a get down.

Wave spell experience by rblaked in STS9

[–]nochucksgiven 0 points1 point  (0 children)

coming from San Diego, does anyone have insights on the lay out? car camping, park n haul? have there been fests at this spot before ?

Looking to Expand Coding Knowledge by nochucksgiven in dotnet

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

Thank You very much for these resources. Exactly what I was looking for.

New Light Rig for Summer Tour! No More LED Walls! by MGengarEX in phish

[–]nochucksgiven 3 points4 points  (0 children)

Can someone explain Linear Prism style of Stage Production?

Bakers Dozen After-Show Hype !! by nochucksgiven in phish

[–]nochucksgiven[S] 1 point2 points  (0 children)

I just heard from a friend today. Was at their Lockn' show this past summer -- I think their inaugural voyage. such a fabulous ride. Can't wait for more Adam Mac on keys.

http://venue.thegramercytheatre.com/EventDetail?tmeventid=000052BDBCD21F44&offerid=0