PDA

View Full Version : how to copy and paste a row of cells from one worksheets to another worksheets?



Alvinkiang
06-28-2006, 12:42 AM
how to copy rows of cells from one worksheet to another worksheet using coding? i know how to pick the rows.

addr = Selection.Row
Rows(addr).Select

mdmackillop
06-28-2006, 12:44 AM
Try using the macro recorder for this, then edit the resultant code to suit. If you need further assistance, post your code noting your problems.

Alvinkiang
06-28-2006, 12:54 AM
alright, thxs.