name a range by referencing a cell value

I'm trying to count the number of rows in column C that have text, and then reference a range of A11:A62 (if 62 was the number of rows that have text). Thanks in advance for any suggestions.

This is working, MATCH(REPT("z",255),C:C), as far as counting the number of rows with text, but it doesn't work for specifying it as a range.


Destination:=Range("A11:INDIRECT("A"&;MATCH(REPT("z",255),C:C))"), Type:=xlFillDefault