使用CURRENTREGION函数通过VBA使用现有数据创建表

So I'm 90% of the way into creating my first big macro project. Thanks for all your help so far everyone! I've come up against an issue however - which I think should be the last issue I should face before putting the macro into use.So I'm 90% of the way into creating my first bi