This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.

Ad by

最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

Ad by

最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

Not sure it’s about VBA or just about cell reference to other sheet.

deep_blue(BLUE)

If it’s related to VBA code, you can view code by Visual Basic Editor: (By View -> Toolbars -> Visual Basic to show Visual Basic Toolbar)

If it’s about cell reference, same sheet reference is little bit different from other sheet reference.

Referring to same sheet: =ColumnRow. e.g. =B22

Referring to other sheet: =SheetName!$Column$Row, e.g. =Sheet1!$A$6

Functions can be used in reference, e.g.

=SUM(A2:A10)
= SUM(Sheet1!$A$2:$F$2)

HTH

(#4622723@0)
Last Updated: 2008-8-16
This post has been archived. It cannot be replied.

Report

Replies, comments and Discussions:

工作学习 / 学科技术讨论 / 向高手请教EXCEL VB问题 -largesuv(黑熊走进玉米地); 2008-8-15 {159} (#4621477@0)
头给了一个EXCEL表, 打开一看, 里面有调用别的SHEET的数据. 用Project explore 看到有几个SHEET, 但我却看不到里面的内容, 没办法UPDATE, 那位指点一下, 如何搞定...多谢.

是不是隐藏了？ -maple2047(枫树湾); 2008-8-15 (#4621550@0)

如果是调用其他workbook的内用，那么被调用的workbook也要打开 -sesk(sesk); 2008-8-16 (#4622149@0)

Not sure it’s about VBA or just about cell reference to other sheet. -deep_blue(BLUE); 2008-8-16 {516} (#4622723@0)
If it’s related to VBA code, you can view code by Visual Basic Editor: (By View -> Toolbars -> Visual Basic to show Visual Basic Toolbar)

If it’s about cell reference, same sheet reference is little bit different from other sheet reference.

Referring to same sheet: =ColumnRow. e.g. =B22

Referring to other sheet: =SheetName!$Column$Row, e.g. =Sheet1!$A$6

Functions can be used in reference, e.g.

=SUM(A2:A10)
= SUM(Sheet1!$A$2:$F$2)

HTH

我用VB EDITOR, 在MS EXCEL OBJECT下看到被调用的OBJEC "SHEET2(CELL SITE), 但用VIEW OBJEC去看是, 菜单是灰的, 看不了. -largesuv(黑熊走进玉米地); 2008-8-16 (#4622753@0)

Double click Sheet2. But I guess it’s empty. Many Excel features do not need code to achieve at all. -deep_blue(BLUE); 2008-8-18 {172} (#4624828@0)
If the content of Sheet2 is not visible, you can view it by
Format -> Sheet -> Unhide...
In Unhide window, select CELL SITE and click OK.

多谢大侠指点, 终于看到它了... -largesuv(黑熊走进玉米地); 2008-8-18 (#4625465@0)

format > sheet > unhide. -jeffrey815(Smartiecat); 2008-8-16 (#4622726@0)

@Calgary

Not sure it’s about VBA or just about cell reference to other sheet.

Replies, comments and Discussions:

More Topics