Is there a way to use ranges with an open end?

[biiiep]

i wanna use all values from a row starting from i.e. c2 to c"end".

is there a syntax to do this as i don’t wanna limit it to c2:c10000 or so?

[ajlittoz]

Duplicate question. See answer here.