Paul Lutus wrote: > Where is the Win32OLE documentation located, please? That way, others > can > confirm your effort and duplicate your experiment (if they are running > Windows). It is here http://www.ruby-doc.org/stdlib/ WIN32OLE#each{|i|...} or each(WIN32OLE)in Methods section Iterates over each item of OLE collection which has IEnumVARIANT interface. excel = WIN32OLE.new('Excel.Application') book = excel.workbooks.add sheets = book.worksheets(1) cells = sheets.cells("A1:A5") cells.each do |cell| cell.value = 10 end Li -- Posted via http://www.ruby-forum.com/.