This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / Excel VBA; 请教在Excel的VB编程里，如何引用另一个wooksheet里的数据？例如：文件名：test.xls, 里面有两个worksheet, 分别为sheet1, sheet2, 如何对sheet1的cells(A1:H1)赋值，使之等于Sheet2的cells(A5:H5)的值？
-goodgoodstudying(daydayup);
2003-1-20
(#988401@0)
-
=sheet2!A5
-lidia(lidia);
2003-1-21
(#990172@0)
-
Here is a VBA answer.For i = 1 To 8
Worksheets("Sheet1").Cells(1, i) = Worksheets("Sheet5").Cells(5, i)
Next
-schen(欲语还休);
2003-1-21
{97}
(#990469@0)
-
Thank you both. I got it.
-goodgoodstudying(daydayup);
2003-1-21
(#990648@0)