ROW Function Criteria Not Accepted

Hi everyone,

I'm trying to get the ROW() function to accept the values written in different cells.

The following formula works and yields an array:

=ROW(1:6)

However, I would like to achieve the same result using the array values 1 and 6 written in different cells e.g. cells A1 and B1 respectively. I'm unsure why the following formula doesn't yield the same result as above:

=ROW(INDIRECT(CONCAT("A", 1)):INDIRECT(CONCAT("B", 1)))

Any help is greatly appreciated.

Thanks,

Jonathan