excel - 我怎样才能将其简化为一句话？

Question

我想在VBA中简化这个，可能吗？

On Error Resume Next

 [B11] = "=Y11"
 [B12] = "=Y12" 
 [B13] = "=Y13"
 [B14] = "=Y14"
 [B15] = "=Y15"
 [B16] = "=Y16"
 ...

End Sub

标签： excelvba

Answer 1

试试下面的代码：

Range("B11:B16") = "=Y11"