Hi,

I am pretty new to coding and this naming convention was supplied to me in another post.

For your first query; this was given to me in another post, which resulted in the below code, and it works well (happy to hear if there is a better approach). This is why I tried following the same approach (in Sub Valuations below) for the code I am having trouble with (Sub Peers):

Sub Valuations()
Dim Tickers As Variant, Ticker As Variant, Rows As Long
Rows = Sheets("Control").Cells(Sheets("Control").Rows.Count, "DA").End(xlUp).Row
Tickers = Sheets("Control").Range("B1:B" & Rows)
Dim ws As Worksheet
Tickers = Sheets("Control").ListObjects("Tickers").ListColumns("Ticker").DataBodyRange.Value
Sheets("Template").Select
Range("B1:P300").Select
Selection.Copy
For Each Ticker In Tickers
     Set ws = ThisWorkbook.Worksheets(Ticker)
     ws.Range("B1").PasteSpecial
Next Ticker
End Sub
Re your second query; no we are not overwriting anything, AN1, and the surrounding cells are blank. I am copying AB1:AL300 from one sheet and pasting to AN1 on another.

Re your third query; as above, that naming convention was suggested in a previous post, for the above code, and it works well. Again, if there are better approaches I would be happy to implement.

Any thoughts on why I am having the error in the Sub Peers, but not the above Sub Valuations?