Counting selected cells
 

Hi

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

Thanks

Wendy

Counting selected cells
 

Try

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

--
Jacob


"Wendy" wrote:

Hi

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

Thanks

Wendy

Counting selected cells
 

After running that line it would just be

Selection.Cells.Count

Tim


"Wendy" wrote in message
...
Hi

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

Thanks

Wendy