Selection minus ActiveCell

[robw]

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

 

[robw]

OK... I found an answer here....

Daily Dose of Excel » Blog Archive » Two new range functions: Union and Subtract