M
Matt
I would like to copy a worksheet to a new workbook using
direct syntax...unfortunately the activeworkbook does not
change to the new workbook when I do so...I would prefer
not to use the Worksheets("Sheet1") approach and instead
use wks (such as set wks = wkb.worksheets(1))
Here is my
Set wkb = thisworkbook
set wks = wkb.worksheets(1)
wks.copy
msgbox ActiveWorkbook.name
How can I make the ActiveWorkbook name change to the
newly created workbook
Thanks
Matt
direct syntax...unfortunately the activeworkbook does not
change to the new workbook when I do so...I would prefer
not to use the Worksheets("Sheet1") approach and instead
use wks (such as set wks = wkb.worksheets(1))
Here is my
Set wkb = thisworkbook
set wks = wkb.worksheets(1)
wks.copy
msgbox ActiveWorkbook.name
How can I make the ActiveWorkbook name change to the
newly created workbook
Thanks
Matt