在公式中增加相对地址 [英] Increment relative address in formula

问题描述

我正在将Visual Basic 6.5用于Excel应用程序.我正在复制包含公式的单元格区域，并且希望能够:

1)粘贴公式并指定行号的相对地址应增加或减少多少
或
2)在粘贴公式后修改公式，以增加或减少公式中的相对地址.

我复制的前三个单元格中的公式如下
='Sheet 1 '！A146  ='Sheet 2'！A146 ='Sheet 2'！b146

我要寻找的最终产品如下:
='Sheet 1'！A147  ='Sheet 2'！A147 ='Sheet 2'！b147

关于如何最好地做到这一点的任何建议?谢谢.

罗恩

I am using Visual Basic 6.5 for an Excel application.  I am copying a range of cells that contain formulas and want to be able to either:

1) paste the formula and specify how much the relative address for row number should increase or decrease
or
2) modify formula after it's been pasted to increase or decrease relative address in formula.

The formula in the first three cells that I copy is as follows
='Sheet 1'!A146  ='Sheet 2'!A146 ='Sheet 2'!b146

The final product I'm looking for is as follows:
='Sheet 1'!A147  ='Sheet 2'!A147 ='Sheet 2'!b147

Any suggestions on how best to accomplish this?  Thanks.

Ron

推荐答案

我不确定vb6.5是否存在，但是我能告诉你什么是的，该论坛适用于vb 7.0及更高版本的.net.

您的问题可能属于VBA或VB6论坛

VBA:http://www.vbforums.com/forumdisplay.php?forumid=1

kaymaf

Im not sure if vb6.5 exists but what i can tell you is that, this forum is for .net for vb version 7.0 and up.

Your question may belongs to VBA or VB6 forum

VBA: http://social.msdn.microsoft.com/forums/en-US/isvvba/threads/

VB6 : http://www.vbforums.com/forumdisplay.php?forumid=1

kaymaf

这篇关于在公式中增加相对地址的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！