SunnyAlv
Active Member
- Joined
- May 23, 2023
- Messages
- 262
- Office Version
- 365
- Platform
- Windows
Hi guys can u help with this problem ![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
i just want to kill/Delete File with Loop but i get eror syntax
this my VBA Code :
Column I fill with File Location
Thanks
i just want to kill/Delete File with Loop but i get eror syntax
this my VBA Code :
Sub KILLEachFileWithDiffLocation()
Dim i As Integer
For i = 1 To Application.CountA(Range("I:I"))
ActiveSheet.UsedRange.AutoFilter 9, Range("I" & i).Value
Kill i
Next i
MsgBox "Done"
End Sub
Column I fill with File Location
Thanks