How do I do a column range from a starting cell until the first non-blank cell?

Also, is there a function, etc. that will return the row number of the first non-blank
cell in a column?

Thanks!