| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting a range according to the longest column
If there is no surrounding data, then one of a few ways...
[A1].CurrentRegion.Select HTH Dana DeLouis John Smith wrote: Say, I have data in A1-A3, B1-B7, C1-C5. How do I programmatically select A1-C7 with one command? "range([A1],C[1].end(xldown)).select" doesn't do it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell/column auto adjusts width to longest text string | Excel Discussion (Misc queries) | |||
| return cell address of longest text string in a range | Excel Discussion (Misc queries) | |||
| Selecting Column Range | Excel Programming | |||
| Longest string in a column | Excel Worksheet Functions | |||
| Selecting a range using a column number reference | Excel Programming | |||
Hybrid Mode
