VBA deleting empty lines.

Hi everybody.
I am starting VBA
i am trying to delete the empty line ofan excel file.
i found on the internet this procedure :

Sub merde()

Dim xlApp As Excel.Application
Dim wbk As Excel.Workbook
Dim Arkadin_carrier As Worksheet
Dim PlageSource As Range ' d


  • You haven't initialized Feuille.

    Try to initialize it should work out

    Set Feuille = ActiveSheet

    For ligne = Feuille.Cells.SpecialCells(xlCellTypeLastCell).Row To 1 Step -1

    VBA Tips & Tricks ([link=http://vbadud.blogspot.com]http://vbadud.blogspot.com[/link])

    C# Code Snippets ([link=http:dotnetdud.blogspot.com]http:dotnetdud.blogspot.com[/link])
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


In this Discussion