zagrijs
04-24-2013, 04:03 AM
Hi
I'm writing code to create a report in a second workbook based on data located in first workbook.
A little form opens with a combobox to enter the name of the new workbook (report) and the value of the combobox is used to name the new workbook.
So far so good. The new workbook is created and renamed as instructed.
But when I use the combobox value in following code to refer to the second workbook I get the error message "Subscript out of range".
I don't know why.
Can anyone help me, pls.
Zagrijs
I'm writing code to create a report in a second workbook based on data located in first workbook.
A little form opens with a combobox to enter the name of the new workbook (report) and the value of the combobox is used to name the new workbook.
So far so good. The new workbook is created and renamed as instructed.
But when I use the combobox value in following code to refer to the second workbook I get the error message "Subscript out of range".
I don't know why.
Can anyone help me, pls.
Zagrijs