| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to find the last line?
Here you go...
iLastRow = UBound(ActiveSheet.UsedRange.Value2, 1) + ActiveSheet.UsedRange.Row - 1 iLastColumn = UBound(ActiveSheet.UsedRange.Value2, 2) + ActiveSheet.UsedRange.Column - 1 -Kent italo wrote: how can i find the number of the last line of a sheet?? urgent, please! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find next line for data entry | Excel Worksheet Functions | |||
| Find and Replace where there are line breaks | Excel Discussion (Misc queries) | |||
| How do I find a value on a line? | Charts and Charting in Excel | |||
| find out line count source in vbe | Excel Programming | |||
| Macro to find the next free line | Excel Programming | |||
Threaded Mode
