Hello Excel Experts,
I have been attempting to create a Macro that inserts text into any open worksheet. I run into the same barrier every time. Excel is requiring me to name a specific workbook to be activated, but the whole point is that I need to be able to run the macro in any desired workbook.
Sub biweeklyholdings()
'
' biweeklyholdings Macro
'
'
Windows("Bi-Weekly Disclaimer.xlsx").Activate
Range("A1:L15").Select
Range("L15").Activate
Selection.Copy
Windows(ActiveWorkbook).Activate
Rows("1:1").Select
Selection.Insert Shift:=xlDown
End Sub
Bookmarks