Is there a simple way to get the value of the last cell in a range. I tried specialcells(xlcelltypelastcell) but ir returns the last cell in the used range which isn't necessarilly the same as the last cell in the selected range. Any help would be grealty appreciated.