This worked! I did make minor tweaks to the code you provided in case someone else is looking at this:

Dim oRng As Range
Dim strFind As String
vs
Dim oRng As Range Dim strFind As String 'on one line

and
strFind = myarray(i, 1)
vs
strFind = myarray(i) 'which returns a subscript out of bounds error

Thanks again, this is a lifesaver and will save a lot of formatting time in the future!