Hi
I need help with this, I am trying to import worksheets into my workbook if certain condition is fulfilled. I am able to do it the first time, but the coding would not import the second, third and etc times. Please help!
Thanks in advance
Hi
I need help with this, I am trying to import worksheets into my workbook if certain condition is fulfilled. I am able to do it the first time, but the coding would not import the second, third and etc times. Please help!
Thanks in advance
it is because when you insert the first sheet, the active sheet is changed and "Example" (where the Button 1 is) is no longer the active one. You have to reselect the original sheet for your code to work.
Like this: (make sure the names are the ones you have in your workbooks)
Please Login or Register to view this content.
Last edited by royUK; 07-07-2011 at 07:52 AM.
Make sure that the range being checked refers to the correct sheet, you don't need to select the sheet
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks