Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
used range question
Hi,
I'm using Office Automation to work on an excelsheet... I need to count the filled rows, I do this by following code: Range range; Range usedRange; range = actualSheet.GetUsedRange(); usedRange = range.GetRows(); int nRows = usedRange.GetCount(); When I create a new Excel Sheet this works fine, but with some files i get wrong values in nRows. The file www.beresko.de/test.xls has 1220 filled rows but my code returns a value of 2295. Is this my fault or a bug, can anyone help me? best regards Andreas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
range question | Excel Programming | |||
Range question | Excel Programming | |||
Used Range Question | Excel Programming | |||
Range question | Excel Programming | |||
Range.Formula and Range question using Excel Automation | Excel Programming |