VBA Help - Copy data to specific sheets

[quant1313]

Hello,

I am trying to copy a specific range of data from a sheet titled "Summary Template" to any worksheet that is not titled "Summary Template" or "Priority Admin" but I am continually getting an error message. Below is the code

Sub Populate()
Dim ws As Worksheet
Dim lockedsheet As Worksheet
lockedsheet = Array("Summary Template", "Priority Admin")

Dim template As Worksheets
Set template = Worksheets("Summary Template")

For Each ws In ThisWorkbook.Sheets
If Not ws.Name = lockedsheet.Name Then
template.Range("A1:Y83").Copy
ws.Range("A2").PasteSpecial (xlPasteAll)
End If
Next ws

End Sub

Please help

 

[Peter_SSs]

Welcome to the MrExcel board!

Duplicate to: VBA Help - Copying Data to specific sheet

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.