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
Bookmarks