I want to make a worksheet reference to a tab that will be imported later....
I though I could to it by referencing a tab within the worksheet with the same formating of the future tab I would be importing....
then...
deleteing that tab and saving the worksheet.
However when I did so excell deleted all my formulas and put in the '#ref' erorr....
can I use an if then statement and do something like if tab exists....
Bookmarks