On Thursday, June 16, 2016 at 10:18:16 PM UTC-7, GS wrote:
A couple of pointers...

TheTaskRng.Parent is a fully qualified ref to the sheet the selected
cells are on.


With Sheets("Project Priorities")
.Range(.Cells(2, blnkCol - 2), .Cells(blnkRow,
blnkCol)).SpecialCells(xlCellTypeBlanks).Delete (xlShiftUp)
End With

..is a fully qualified ref that does not require the sheet be the
active sheet.

HTH

--
Garry



I'll give the With statement another try. I went there to start but did not work for me. Maybe I had something else out of kilter.

And as I look at your With right now, I see now I was omitting the .Range (dot).

DUH!!

Thanks Garry