Counting selected cells

[Wendy]

Hi

How do I count how many cells the command Range(Selection,
Selection.End(xlToRight)).Select has selected?

Thanks

Wendy

 

[Jacob Skaria]

Try

Msgbox Range(Selection, Selection.End(xlToRight)).Cells.Count

 

[Tim Williams]

After running that line it would just be

Selection.Cells.Count

Tim