阅读背景:

使用For / Each循环但跳过活动单元VBA

来源:互联网 

So I am trying to write a For Each loop to look through an entire row. If it finds the word "Specialty" Copy it over to the next three cells. It does this part fine, but then when it loops around, of course the next cell has "Specialty" in it bc it just copied it over. I need to figure out how to say, if you've found "Specialty" and copied it over, jump 4 cells over and begin searching again..... Tried Offsetting the active cell but didn't work. Any ideas? Thanks!So I am trying to write a For Each loop to look




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: