Greetings,
I am receiving the "method Range of object worksheet failed" error on the line below within the context of the short script further below.
.Range(h, h.End(xlToRight)).Copy
For Each ws In COM.Worksheets
With ws
k = .Cells(Rows.Count, "A").End(xlUp).Row...