Hello! Firstly thanks everyone for their help so far with my many questions. I really appreciate it and I am learning loads as a result.
i have a slightly more complex question i think...
i need to know if a worksheet exists in a given workbook. Over time, worksheets have been added, and removed, the result being that i have something like Sheet1, Sheet2, Sheet5, Sheet9 etc.
is worksheets(3) the same as worksheets("Sheet5") in the above example? If not, how can I loop through each to find out if the required worksheet exists?
Visit my site: http://www.drybonesuk.com