How to use Google Spreadsheet ADDRESS function to create a range

Was stuck on something very similar. Something like this should work.

=MAX(INDIRECT(1, COLUMN()) & ":" & ADDRESS(ROW()-1, COLUMN())))

This might be useful too if you want to get the sting address for a range:

=ADDRESS(row(A3:A6),COLUMN(A3:A6))&":"&ADDRESS(row(A3:A6)+rows(A3:A6)-1,COLUMN(A3:A6)+COLUMNS(A3:A6)-1)

This will return a string on the range, in this case

$A$3:$A$6