cptStatus - ClearContents not working with certain combination of selections

[AronGahagan]

Problem:

User reports "Application-defined or object-defined error".

Status/cptStatusSheet_bas.bas:2036:  If Not oClearRange Is Nothing Then oClearRange.ClearContents
Status/cptStatusSheet_bas.bas:2221:  oWorksheet.Rows(lngRow + lngItem).ClearContents
Status/cptStatusSheet_bas.bas:2224:  oWorksheet.Rows(lngRow + lngItem).ClearContents

Solution:

TBD - testing needed. No discernible reason why this should be happening. We unlocked cells manually and then code proceeded normally. Happened on Row 16 -- perhaps it's the first time that SLOC was run on the newly generated sheet?

Todo:

• [x] assign this issue
• [x] label the issue for enhancement or bug
• [x] label the issue with codemodule (so fixes can be aggregated and hotfixed together)
• [x] checkout appropriate branch and create topic branch
• [x] design, code and test
• [x] update codemodule x.y.z
• [x] update CurrentVersions.xml manually
• [x] commit changes prefix comment with Issue #XXX -
• [x] merge topic into appropriate branch(es) and push
• [x] delete topic branch

[AronGahagan]

There must have been a change in MSFT products, because this error had never tripped before. The code has been in there for a long time. I changed oRange.ClearContents to oRange.Value = "" to bypass. Merged into next-release.