Correct. I would do it that way: Record the macro for just one set of cells. Then you can look at that program, and learn from it how those VBA commands should be written. With a little work (and I'll help), you should then be able to write IF statements that will enable your program to know how to do the same thing for the right cells next time.