Hello! I have an Excel tab called "Titlelist" that I'm trying to write a VBA code to copy this tab to a new workbook and then clear its contents from the first workbook. The issue I'm running into is the tab is connected to a database, so when I try to copy it to a new workbook, it's just coming up blank.
I've tried copying and pasting as values, copying to a new tab in the same workbook then trying to copy that tab and neither works.
Any assistance you can provide is greatly appreciated!
I've tried copying and pasting as values, copying to a new tab in the same workbook then trying to copy that tab and neither works.
Any assistance you can provide is greatly appreciated!