I need to get the column number of the last non-blank cell in a row. I
am using the Excel Com object in a .NET app to get this done

I have something like this
Range rg = xSheet.get_Range("A1","A1"); // xSheet is the worksheet
object.
int lastColumnNumber = rg.Cells.....

I am not sure what the method call to do or the steps to follow.
Any help is appreciated,
- K.