| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number of colons
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I get rid of these colons | New Users to Excel | |||
| Excel 2007 Format issue, colons being substituted for decimals. | Excel Discussion (Misc queries) | |||
| time entry with am/pm and no colons | Excel Discussion (Misc queries) | |||
| insert colons in time automatically when input to cell | Excel Worksheet Functions | |||
| Excel formula, 2 colons query to sum values in colon 3 | Excel Programming | |||
Threaded Mode
