VBA对齐问题 [英] VBA Alignment Issue

问题描述

我需要将此语义转换为Excel VBA语法.希望有人能帮忙.

Hi,

I need to convert this semantic into Excel VBA syntax. I hope someone can help.

FOR row 1 to row 1000
    IF a3 = d3 THEN
        DO NOTHING
    ELSE
        SHIFT DE3:DE1000 1 down
    END IF
NEXT

更新:感谢您的回复JaikeC

您快到了.如果满足条件，则不进行任何操作，否则将表数组(Dx:E(x + 1000))向下移动1 ..，然后重复for循环.

x是计数器的位置

如果您能想到更好的编码方法，将不胜感激.

再次感谢！

UPDATE: Thank you for the reply JaikeC

You''re almost there. IF the condition is met, DO NOTHING, ELSE SHIFT the table array (Dx:E(x+1000)) down 1.. and then repeat the for loop.

x is the position of the counter

If you can think of a better way to code it.. it would be appreciateed.

Thanks again!

推荐答案

我有点理解了你的意思，但是你可以再解释一下吗.我想这就是你的意思...

向下看一列(A)
如果A当前行中的值等于D列中同一行的值...请不要输入任何内容

如果值不同...
将值向下移动(某处...现在丢失)

I sorta get what you mean but can you explain it a bit more. I think this is what you mean...

Look down a column (A)
if the value in the current row of A equals the value of the same row in column D...dont to anything

If the values are different...
move the value down (somewhere... lost now)

我通过编辑帖子来回复，嘿，我不知道这是否在电子邮件中提示您:)

I replied by editing my post, hehe, i dont know if that prompted you in the email :)

这篇关于VBA对齐问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！