From: BillR on 9 Apr 2010 11:18 I am trying to do something like this: for row=3 to 17 select columns A:F, row copy selection select another range on another worksheet paste what I copied too that range. next row I have been able to select one colun at a time, but can't select the whole range from A to F on the row I am on. Thanks. -- BillR From: joel on 9 Apr 2010 11:43 Simple Range("A3","F17") Range(range("A3"),range("F17")) Range(Range("A3"),cells(17,6)) Range(cells(3,1),cells(17,6)) -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=194340 http://www.thecodecage.com/forumz From: BillR on 14 Apr 2010 15:36 I think I mislead you with the description of the problem. On sheet1 I want to go from rows 3 to 17 one at a time. If cell D on that row is greater than 0, I want to copy A:F and paste it to A2 on sheet2. Then I want to insert a row on sheet2 to make room for the next copy. Then go back to sheet1 and use the next row to do it all over again until I get row 17 copied if D17 is greater than 0. Thanks for the help. -- BillR "joel" wrote: > > Simple > > Range("A3","F17") > > Range(range("A3"),range("F17")) > > Range(Range("A3"),cells(17,6)) > > Range(cells(3,1),cells(17,6)) > > > -- > joel > ------------------------------------------------------------------------ > joel's Profile: 229 > View this thread: http://www.thecodecage.com/forumz/showthread.php?t=194340 > > http://www.thecodecage.com/forumz > > . >  |  Pages: 1 Prev: DisplyaAlerts ProblemNext: Updating Pivot Tables using a List