Hi All,
I have a named range ("Priority") which sits in cells K10:K21.
Of these 12 cells I need to know how many are used so that I can set that value as how many times I paste the "EEName" from this sheet to another sheet.
So if there are 6 lines filled out in "Priority" I need to copy "EEName", move to the Submissions tab, and paste the EEName 6 times into the next available cell in column A.

The closest I think I can get is without using the named range.

Set NumEntries = Range(Cells(10, 11), Cells(21, 11))
If Application.WorksheetFunction.CountIf(NumEntries) <> "" Then
When I finally find that value I think I can use this to paste it:
Worksheets("Submissions").Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Resize(NumEntries).Value = Range("EEName").Value
Anyone know how to finish what I started?
Thanks in advance... unfortunately I can't upload anything from work. Total lockdown.