Hi:
The following code giving application error:
rs.Range(Cells(sr, 2), Cells(sr, 13)).Value = ds.Range(Cells(tr, cn), Cells(tr, cn + 11)).Value
--
rs is my rport shhet,ds is my data sheet in 2 different workbook. I am trying to copy from ds to rs.
at the first loop iteration:
sr =10,tr=10,cn=2
--Thanks in advance
The following code giving application error:
rs.Range(Cells(sr, 2), Cells(sr, 13)).Value = ds.Range(Cells(tr, cn), Cells(tr, cn + 11)).Value
--
rs is my rport shhet,ds is my data sheet in 2 different workbook. I am trying to copy from ds to rs.
at the first loop iteration:
sr =10,tr=10,cn=2
--Thanks in advance