I can select the last cell using SELECT.LAST.CELL()

then i can push the column or row of the SELECTION() into a variable and use that but since excel knows what it considers the last cell to be, i would imagine there is just a reference like LAST.CELL() but i can't find it in my macrofun doc. or earlier documentation.

thanks,

brian