Below is my code
iStart = 38
'iEnd = Range("A" & iStart).End(xlDown).Row
Set d = CreateObject("scripting.dictionary")
With d
For Each e In Range("E39:E108").Value
'd.CompareMode = vbTextCompare
If Range("J", iStart).Value = "" Then
d.Item(g) = d.Item(g) + 1
iStart = iStart + 1
End If
Next e
Sheets(6).Range("J4").Resize(.count).Insert xlDown
Sheets(6).Range("J4").Resize(.count) = Application.Transpose(.Items)
End With
I am getting an error " Method 'Range' of object _'Global' " failed at line
If Range("J", iStart).Value = "" Then
I have tried but failed to correct without knowing whats wrong.
Can you please help me with this error ?
iStart = 38
'iEnd = Range("A" & iStart).End(xlDown).Row
Set d = CreateObject("scripting.dictionary")
With d
For Each e In Range("E39:E108").Value
'd.CompareMode = vbTextCompare
If Range("J", iStart).Value = "" Then
d.Item(g) = d.Item(g) + 1
iStart = iStart + 1
End If
Next e
Sheets(6).Range("J4").Resize(.count).Insert xlDown
Sheets(6).Range("J4").Resize(.count) = Application.Transpose(.Items)
End With
I am getting an error " Method 'Range' of object _'Global' " failed at line
If Range("J", iStart).Value = "" Then
I have tried but failed to correct without knowing whats wrong.
Can you please help me with this error ?