Hi,
Any thoughts on this please....
Inside a VBA procedure the set of cells I currently have selected in a worksheet are represented by the object “Selection”, which includes the active cell represented by the object “ActiveCell”.
If I know that the cells I have selected in the worksheet consist of a rectangular set of cells, AND a single other cell (the active cell) that is (typically) chosen to be not contiguous with the rectangular set, is there a way I can qualify the Selection object so that it refers only to the rectangular set . ie. excludes the active cell ?
Thanks
Rob
Any thoughts on this please....
Inside a VBA procedure the set of cells I currently have selected in a worksheet are represented by the object “Selection”, which includes the active cell represented by the object “ActiveCell”.
If I know that the cells I have selected in the worksheet consist of a rectangular set of cells, AND a single other cell (the active cell) that is (typically) chosen to be not contiguous with the rectangular set, is there a way I can qualify the Selection object so that it refers only to the rectangular set . ie. excludes the active cell ?
Thanks
Rob