如何使用find column index funciton同时删除多个列

I have done a bit of googling and can not figure out how to delete multiple columns at the same time. Being that the data that will be inputted into this tool will not be consistent I have to use a find function to denote which column to delete. Right now, only the first delete function works and the rest are ignored. I have used messageboxes to insure the find functions are properly pulling the correct column index. Does anyone have any ideas on how to delete multiple? Thanks! I have done a bit of googling and can not figur