Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UsedRange problem
Hi all
I used UsedRange from the ActiveSheet to loop through each cell and process data. Sometimes I have blank rows inside my range. This works fine with UsedRange. Sometimes the first few rows are blanks and they must be processed as well. However, UsedRange does not pick them up. I appreciate that this is the intended functionality of the UsedRange. But is it possible for UsedRange to be discriminatory and exclude only the trailing blank rows? I cannot used a fixed range as the number of columns and cells in my sheet can be different for different files. Any ideas? Many thanks Andy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UsedRange problem
Andy
Try something like this Range("B2).select 'place the activecell in the data area ActiveCell.CurrentRegion.Select This selects empty cells and headers Regards Peter -----Original Message----- Hi all I used UsedRange from the ActiveSheet to loop through each cell and process data. Sometimes I have blank rows inside my range. This works fine with UsedRange. Sometimes the first few rows are blanks and they must be processed as well. However, UsedRange does not pick them up. I appreciate that this is the intended functionality of the UsedRange. But is it possible for UsedRange to be discriminatory and exclude only the trailing blank rows? I cannot used a fixed range as the number of columns and cells in my sheet can be different for different files. Any ideas? Many thanks Andy . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
UsedRange problem
Many thanks Jim and Peter. I will test them both out.
Range("A1", Cells.SpecialCells(xlCellTypeLastCell)) Adjust A1 if you want to start from another cell. -- Jim Rech Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is worksheet.usedrange empty? | Excel Worksheet Functions | |||
Excel 2007 BUG UsedRange/LastCell differences with Excel2003. | Excel Discussion (Misc queries) | |||
Real Value of .UsedRange.Rows.Count | Excel Worksheet Functions | |||
Find Usedrange question | Excel Programming | |||
Usedrange | Excel Programming |