質問するログイン新規登録

回答編集履歴

1

コード修正

2019/12/13 10:23

投稿

hatena19
hatena19

スコア34367

answer CHANGED
@@ -14,7 +14,7 @@
14
14
  Set rng = Range("A1").CurrentRegion
15
15
  Dim varList() As Variant
16
16
  varList = rng.Value
17
- Dim r As Long, c As Long, Temp As Variant
17
+ Dim r As Long, c As Long
18
18
  For r = 1 To UBound(varList, 1)
19
19
  For c = 1 To UBound(varList, 2)
20
20
  If IsEmpty(varList(r, c)) Then