尝试在VB.net中设置范围时出现“DBNull”错误。数据库是Excel

I've written a pretty useful macro within Excel in VBA and am attempting to transfer it to a stand-alone windows application written in VB.net. I've found all the referencing pretty confusing and am now facing trouble in converting the general syntax of my code. I've written a pretty useful macro within Excel