| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range of cell
Hello everyone:
How can I know if the ranage selected is more than one cell or a selection of diffrent ranges? Cheers, Andres |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Range of cell
Andres A wrote:
Hello everyone: How can I know if the ranage selected is more than one cell or a selection of diffrent ranges? Cheers, Andres RangeName.Count 1 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Range of cell
Andres,
Forgot to answer the first part of your question. "selection.rows.count" AND "selection.columns.count" will tell you if there is more than 1 cell in the range. "Selection.cells.Count" gives the total number of cells in the total selection. regards JohnI "Andres A" wrote in message ... Hello everyone: How can I know if the ranage selected is more than one cell or a selection of diffrent ranges? Cheers, Andres |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Range of cell
Tom,
Thanks for that. I should have tested. I was going from memory which in this case was faulty. regards, JohnI "Tom Ogilvy" wrote in message ... "selection.rows.count" AND "selection.columns.count" will tell you if there is more than 1 cell in the range. ? Range("A1,C9:M15,Z20").Rows.count 1 ? range("A1,c9:M15,Z20").Columns.Count 1 You are correct aboutn ? range("A1,c9:M15,Z20").Count 79 -- Regards, Tom Ogilvy "JohnI in Brisbane" wrote in message ... Andres, Forgot to answer the first part of your question. "selection.rows.count" AND "selection.columns.count" will tell you if there is more than 1 cell in the range. "Selection.cells.Count" gives the total number of cells in the total selection. regards JohnI "Andres A" wrote in message ... Hello everyone: How can I know if the ranage selected is more than one cell or a selection of diffrent ranges? Cheers, Andres |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
| RANGE EXCEL copy cell that meets criteria in a range | Excel Worksheet Functions | |||
| copy range and paste into every 3rd cell of new range | New Users to Excel | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Linear Mode
