get worksheet range as collection

Hi All, I want to import some columns from an excel file and A-D into my collection and as per BP i need to provide an end cell. How can i provide an end cell number in order to be dynamical? Or which is the best approach of doing this kind of partial import. Thank you, Ionut