For the life of my, I can't figure this out. I'm sure it's obvious. I'm getting a subscript error on the line in red below.
Sub UpdateWatchlistM()
Dim k1 As Worksheet, k2 As Worksheet
Dim FirstBlankRow As Long, r As Long, StartingRow As Long
Dim ESFound As Range
Set k1 =...