如何使用VBA识别excel中的分页符，条件各不相同

This is a problem I've been wrestling with for some time. Forgive me for not citing the exact threads I've researched, but I've not been keeping a log. The code sample I have below has been constructed from reviewing many threads on this topic. However, the exact solution I need still evades me.This is a problem I've been wrestling with for