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
Glad to help!
What's important about programming VBA is that you always use *fully
qualified object refs* in code. This is way more efficient approach
than having to '.Select' or '.Activate' things. (Note, though, that
some actions require objects be selected/activated!)
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus