Question about the ROW function

[caniever]

I have come across this....I know the most "normal" way to use ROW function is to give it a cell ref, e.g. A10, B3. But when I put an number array as an argument into the ROW function, e.g. row(4, 5), it will return {4,5}...I guess it interprets the argument as row 4 and row 5, so it spits out {4,5} as a result.

However, when I just put in a single number, i.e. row(4), it can't calculate. Can anyone shed light on the logic behind that? Thank you!

 

[Ron Coderre]

I don't know how you get a value returned. When I try any variation of what you posted, I get an error: "You've entered too many arguments for this function"