Welcome

Welcome By Online Tutorial- Advance MS Office Excel - Word - Access - Power Point - Batch File Tips and Tricks, How to Use Indirect function, How to Apply Image Vlookup, How to Apply Double Vlookup and many more advance tips and tricks subscribe our video channel and get more new updated video https://www.youtube.com/user/renuka1971

excel vba code sample for deleting blank rows rows


excel vba code sample for deleting blank rows rows


Dim counter As Integer, y As Integer
 counter = 0
 
 For y = 1 To 10
     If Cells(y, 1).Value <> "" Then
         Cells(counter + 1, 2).Value = Cells(y, 1).Value
         counter = counter + 1
     End If
Next y