In article ,
"Bill" wrote:

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

Can you elaborate?

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

Try...

=MATCH(TRUE,A1:A100<"",0)

....confirmed with CONTROL+SHIFT+ENTER.