| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get actual rows number in Excel using VBA?
Hi all,
Currently in my sheet1, the actual rows number is 20, that is, only the first 20 rows have content in it. But I use ActiveSheet.UsedRange.Rows.Count, and it gets 26, and sometimes more. Why? How can I get the exactly 20? Thanks. michael |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| actual row number | Excel Worksheet Functions | |||
| I'm getting ##### in summation instead of the actual number | Excel Discussion (Misc queries) | |||
| Currency format for Excel 2007 not displaying actual number | Excel Discussion (Misc queries) | |||
| Actual value a non-zero number but display is Zero | Excel Discussion (Misc queries) | |||
| How do i Use actual number displayed? | Excel Worksheet Functions | |||
Threaded Mode
