I need to be able to read data in specific columns from an excel sheet. The column range is dynamic (could be A1:A20 sometimes or A1:A27 in other cases depending on how the data is fed into the excel sheet). Does specifying a range NAME work in this case. <BR><BR>The preference is not to have to NAME a range and read that NAME in order to retrieve the data. <BR><BR>Can it be done automatically by only specifying columns so that we can avoid a manual process here.<BR><BR>help