| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to get actual rows number in Excel using VBA?
..UsedRange means the cells have been used, but does not mean that they are
necessarily still in use. ..CurrentRegion is good for finding the current range, as long as it is a continuous rectangular range. So Range("A1").CurrentRegion.Rows.Count tells how many rows are included in the region starting at A1. -- - K Dales " wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to get actual rows number in Excel using VBA?
Got it!
Thank you very much, Dales! It really helps! michael |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to get actual rows number in Excel using VBA?
Got it!
Thank you very much, Dales! It really helps! michael |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to get actual rows number in Excel using VBA?
In a situation where that doesn't work, delete the extra rows (and/or
columns) using Edit/Delete, than Save. Sometimes I have to do a Save As. You can use Ctrl+End to see what Excel sees as the end of the used range. " wrote: Got it! Thank you very much, Dales! It really helps! michael |
| Reply |
| 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 | |||
Linear Mode
