| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Extents of Data
I believe that there is a simple function available in VBA that searches for
the extens of the data once a cell is highlighted. For example by clicking in the centre of a large range of data, this command effectively then returns the extents allowing easy definition of a range. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find Extents of Data
I think this is what you want activecell.CurrentRegion.selec -- duan ----------------------------------------------------------------------- duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162 View this thread: http://www.excelforum.com/showthread.php?threadid=26595 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find formatting doesn't work: "Excel cannot find data" | Excel Discussion (Misc queries) | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| Unable To Reset Extents Of Spreadsheet | Excel Discussion (Misc queries) | |||
| The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) | |||
| FIND DATA WITHIN DATA (V-OR-H LOOKUP/FIND/MATCH?) | Excel Worksheet Functions | |||
Linear Mode
