what's ActiveCell.Count

[mscallisto]

I've read the "Help" on ActiveCell.Count and still don't understand what exactly it does.

Can anyone show me a useful example of when to use ActiveCell.Count?

 

[RobBroekhuis]

I can't think of an instance when activecell.count would not be 1 - there is only one active cell. On the other hand, selection.count will return the number of cells in the current selection.
Rob

 

[mscallisto]

Thanks RobBroekhuis you've confirmed my suspicions that ActiveCell.Count by itself is of little value.