Hi all !! i have a problem with the execution ... it hangs on the Resize shiftright;
please is it written correctly or should change something ? tx! paolo
![]()
Option Explicit Public i as Long Sub Mia() Dim aWB As Workbook Dim aWS As Worksheet Set aWB = ThisWorkbook Set aWS = aWB.Worksheets("L") 'On Error Resume Next For i = 2 To 1000 If aWS.Range("A" & i).Value <> 0 Then Call MiaBis End If End Sub Sub MiaBis() Sheets("LList").Range("CAA" & i).Resize(0, 5).Insert Shift:=xlToRight End Sub
Bookmarks