Hi guys,

I have a template spreadsheet which has a macro in it that is accessed from another workbook. This template will eventially be about 30 different workbooks. I have this code:

    
    Sheets("Fundraiser").Select
    Range("B60:G261").Select
    Selection.Copy
    ActiveWindow.SmallScroll Down:=12
    Range("B263").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False
    Selection.Copy
    Windows("Fundraiser.xls").Activate
    Rows("2:2").Select
    Selection.Insert Shift:=xlDown
    Windows("AFBP_test.xls").Activate
    Application.CutCopyMode = False
    Selection.ClearContents
    ActiveWindow.SmallScroll Down:=-246
    Range("D17").Select
    ActiveWindow.SmallScroll Down:=-30
    Range("B2").Select
I need the code on the line where it selects the "AFBP_text.xls" to select a range from a page in the workbook. The range is "Scriptname" and will be in every workbook.

Obviously the scriptname range will change for each workbook, but the macro needs to run the same. So instead of manually changing which workbook it selects in the code for each new workbook I create from the template, I'm wondering if there is code to connect to this range automatically?

Thank you in advance!

Matt