[转帖]OFFSET引用函数应用大全

11111

[em02]

moonmybox

正需要

liuhao_goody

<p>学习下，收藏。</p>[em01]

漂泊的云

???

想插翅飞

<p>thank you</p>

kehaif

学习学习

ANYCALLe488

看看，谢谢楼主分享！

lujjj

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman';">For i=1 to n <p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman';">A1=sheet1.cells(1,1) <p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman';">A1=A1+B1 <p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman';">sheet1.cells(1,1)=A1 <p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman';">next n<p></p></span></p>

bobzjh

<p>谢谢楼主</p>

难注册难登录

<p>来学学,谢谢啦!</p>[em01][em01]