Selecting Cell Ranges from VBA Automation

I am new to VBA automation, and am trying to process some selected cells. I had referred some code related to Range class, but form the sample code i got through internet resources i am able to select only one cell. how to modify the below code to get a list of cells.


hr = AutoWrap(DISPATCH_PROPERTYGET, &vCell, irange, L"Item", 2, COleVariant((short)(1)), COleVariant((short)(1)));