Hi!
I have a workbook that contains a lot of source data.
This workbook contains a macro to open another workbook to perform other work.
I would like to automate the process of adding a named range's value to the new workbook within the user form.
something like....but in a more autonomous way. Is that possible with having a dynamic source workbook name?
I have a workbook that contains a lot of source data.
This workbook contains a macro to open another workbook to perform other work.
I would like to automate the process of adding a named range's value to the new workbook within the user form.
something like....but in a more autonomous way. Is that possible with having a dynamic source workbook name?
Code:
wkbk2.range("Project").Value = wkbk1.range("Project").Value