Hi All,
i use a line of code to save my work book (Workbooks("price.xlsm").Save)
i then changed the code to find the workbook name from a range on the active sheet (Workbooks(Range("A10").Value).Save)
I now want to find the workbook name on sheet 2 and save it.
what do i need to change for excel to look for the range on sheet 2?
Thanks in advance.
i use a line of code to save my work book (Workbooks("price.xlsm").Save)
i then changed the code to find the workbook name from a range on the active sheet (Workbooks(Range("A10").Value).Save)
I now want to find the workbook name on sheet 2 and save it.
what do i need to change for excel to look for the range on sheet 2?
Thanks in advance.