Selection minus ActiveCell

robw

Board Regular
Joined
Dec 18, 2002
Messages
159
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
 

Forum statistics

Threads
1,078,253
Messages
5,339,110
Members
399,279
Latest member
danidanidaniel

Some videos you may like

This Week's Hot Topics

Top