| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine used range of worksheet
I am using CreateObject in Access to rummage around in an Excel worksheet for data I am copying into the database
How can I determine what the bounds of the occupied area of the worksheet are? I see objects showing the bounds of active areas are, but nothing that shows the full range of used cells. I need these vaules to limit the for/next loops that are doing the rummaging. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| determine a range using a formula | Excel Worksheet Functions | |||
| Determine if a value in a range is close to the value of another c | Excel Worksheet Functions | |||
| Determine if a value in a range is close to the value of another c | Excel Worksheet Functions | |||
| Determine whether a value is in a range of cells | Excel Discussion (Misc queries) | |||
| Determine range with VBA | Excel Programming | |||
![Ian Smith[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
