Macro saving workbook from range on sheet 2

[Luke1690]

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.

 

[eiloken]

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.

you assign it to sheet 2:

Workbooks(Sheets("Sheet2").Range("A10").Value).Save

 

[Luke1690]

you assign it to sheet 2:

Workbooks(Sheets("Sheet2").Range("A10").Value).Save

Thanks mate, I couldn't get my head round it. i tried loads of different combinations of that.

Thanks for your quick response.