Reading an Excel excluding hidden values

[kgarun]

Hi All,
I have a problem with reading Excel, Some values in the Excel made as hidden (as Subtotal).
In my application I need not want to read
hidden sections of that Excel.
I am using the Active X refnum "Excel._Application" but I have not found any property regarding that.Pls help me to solve this problem.

[Jarrod_S.]

I would search through the Excel help to find out exactly what this property might be called in the Excel Object Model. Then go to www.msdn.com and search for Excel Object Model. The first link should be a complete reference for all things ActiveX in Excel. Hope this helps!

[Michael_Munroe]

The hidden property is available on a Range object.  The best way to see if the cell is hidden is by Range.EntireRow.Hidden.  It returns either True or False.  See attached image.

[kgarun]

Hi,Michael

Thanks for the valuable Suggestion.
I got the desired result,

Thanks again )):
ArunKG