Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Loop and delete entire row by vba

0

check wheather column C has data if yes then do nothing if no then delete that entire row by vba
file name sonu.csv file is located in C:\Users\soniya\Desktop
i will put a macro in different file and both files are located in same place
save it after the process completed and close it

Answer
Discuss

Discussion

Thank you for your clear programming instructions. I’m sure, since you don’t seem to know how to ask for help you also didn’t learn how to say thank you when you receive it. I shall not help you. Learn some basic social skills.
Variatus (rep: 4889) Sep 14, '19 at 3:38 am
I never disrespected anyone in this forum
If i have done so then plz let me know?
kajaljha56788 (rep: 14) Sep 14, '19 at 4:48 am
Add to Discussion

Answers

0
Selected Answer
Sub Mysub()

   Dim wbk1 As Workbook
   Dim wsh1 As Worksheet

   Application.ScreenUpdating = False

   Set wbk1 = Workbooks.Open(ThisWorkbook.Path & "\BasketOrder..csv")
   Set wsh1 = wbk1.Worksheets(1)

   With wsh1
   wsh1.Columns("F").SpecialCells(xlCellTypeBlanks).EntireRow.Delete

End With


   Application.DisplayAlerts = False
   wbk1.Close SaveChanges:=True
   Application.DisplayAlerts = True

   Application.ScreenUpdating = True

End Sub
Discuss

Discussion

Problem Solved Thnx Alot Variatus Mam & Style36 for giving ur Precious Time and Great Support to this Post Have a Great Day
kajaljha56788 (rep: 14) Sep 15, '19 at 2:21 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login