Excel get_Range

[Guest]

Hi,

I use the following statement to get a range in Excel worksheet:

Excel.Range oRange = oSheet.get_Range("A1", "A10");

How can I get the entire column?

Thanks.

 

[Alvin Bruney [MVP]]

A column is represented by a range as well. You can use the get used range
method call. That provides the used column range.