| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to set Range variable to point to End(xlDown) cell?
What's the best way to set a Range variable to point to the
End(xlDown) cell? The following seems to do the job. But can this be improved? Dim rng as Range Set rng = Range(Range("C3").End(xlDown).Address) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use xldown to select a range of cells | Excel Discussion (Misc queries) | |||
| End(xldown) not always going to last cell? | Excel Programming | |||
| Unable to use Range.End(xlDown) method | Excel Programming | |||
| Unable to get last filled cell address from Range.End(xlDown) method | Excel Programming | |||
| Select the next row after xldown range | Excel Programming | |||
Threaded Mode
