避免尝试使用VBA和ADO / SQL将NULL值加载到数组中以从Excel工作表中提取数据

I have some simple code that will load all the data from an excel sheet into an array but I am getting an error 94 inproper use of null due to the fact that my source sheet has some blank columns IE: Q through EA are blank columns but A -P and EB - EF have data. (terrible design for an excel sheet being used as a table I know,.. but I didn't do it) Seeing as I cant redesign the table.. how can I skip the blanks as to avoid causing errors when loading them into my array?I have some simple code that will load all the