How the code will be written if the data from sheet1 is located in the
following cells:
A1
B1
C1
D1
Then I want this data to written in the following cells of the sheet2:
A1,A2,A3,A4

Thanks in advance....

Maperalia



i
"PY & Associates" wrote:

You did not indicate where to copy to. Meanwhile, how is this?

Range(ActiveCell, ActiveCell.End(xlDown)).EntireRow.copy
sheets(2).range("....)
YOu do not need looping


"cunning" wrote:


How would I go about coding a Loop to read rows of data from Sheet1 then
write the data to Sheet2 until an empty row is encountered?

Thanks for any assistance.


--
cunning
------------------------------------------------------------------------
cunning's Profile: http://www.excelforum.com/member.php...o&userid=26738
View this thread: http://www.excelforum.com/showthread...hreadid=399965