我有以下代码:
Dim r1 As Range, r2 As Range, multiAreaRange As Range, lcopytorow As Long对于表中的第一项,代码运行良好。但是,我需要对整个表(大约3800行)进行复制。我希望避免复制整个行,而只是复制上面所述的定义范围。我想我必须定义一个循环,通过这个循环代码可以跳过,但是我不知道怎么做。希望我的解释是有意义的,对vba来说是新的,但学习很快。任何帮助都将不胜感激。谢谢你们。
value.govt_agency + ", " + @city_or_municipality + ", " + value.province + "</option>" Department of Blah blah, City of This thing, Province of this stuffDepartment