From: Li Chen Date: 2009-10-11T07:41:47+09:00 Subject: Re: for loop in excel macro Rodrigo Bermejo wrote: > You can perform this task using Ruby. > You can find plenty of info about right here: > > http://rubyonwindows.blogspot.com/search/label/excel > > > Then the required loop can be implemented in the ruby way you are used > to. Hi Rodrigo, Thanks for the link. I might refer it if I use a lot of Excel automation. But I need a quick method for my project immediately. I just get some help from VBA group in Yahoo: Range("A1:D1,A" & i + 2 & ":D" & i + 2) Li -- Posted via http://www.ruby-forum.com/.