Hi everyone. I am new here. I am getting into more advanced excel stuff with my job. In this particular case I need to get all of the cells in a certain column until I hit a blank one and stop there. Doing this in vba is fairly easy but I need it as an excel formula. Here is what I have so far:

='Settings-Objectives'!$C$2:(--until first blank cell)
obviously the part in parenthesis is what I need help with.

It seems fairly straight forward and simple but i have not yet found the solution after searching for some time.

Thanks in advance!