Hello,
I've a file Excel with a pivot table and some macro. When I open this file, I need to wait some minutes (I can see the logo of Excel and the writing "Calculation ongoing (8 thread)").
Can be the presence of this macro? It uses to delete some rows.
How can I resolve this problem? Thank you.
I've a file Excel with a pivot table and some macro. When I open this file, I need to wait some minutes (I can see the logo of Excel and the writing "Calculation ongoing (8 thread)").
Can be the presence of this macro? It uses to delete some rows.
Code:
Dim LR3 As Long, i3 As Long
With Sheets("Import")
LR3 = .Range("A" & .Rows.Count).End(xlUp).Row
For i3 = LR3 To 2 Step -1
If IsNumeric(.Range("A" & i3).Value) = False And _
Len(.Range("A" & i3).Value) > 0 Then
Else
.Rows(i3).Delete
End If
Next i3
End With
How can I resolve this problem? Thank you.
Last edited by a moderator: