Unanswered: Help - Check if Range Exists Before Importing
I am running a regular import process through a menu that determines which files to import based on check boxes. Due to the large number of files I am looping through filenames using variables for months/years etc.
The problem I have is that some files have data split over 2 sheets and others don't. The named ranges are the same bar a 1 or 2 on the end in all files.
I am using the Transferspreadsheet command and know that I will get an error on files that don't contain the second range. Is there a way of checking to see if the range exists and run the command if true else goto the next stage in the loop?