It is not safe to make that assumption. The space character in an address
indicates Intersection, so you could have an address with two colons and no
commas.


Set R = Range("A1:C5 B5:D10")
Debug.Print R.Address ' displays B5:C5


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



"Gary''s Student" wrote in message
...
Is is safe to assume that if the address of a range does not contain a
comma,
that it can contain at most one colon??
--
Gary''s Student - gsnu200793