VBA deleting empty lines.

sherby88

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

shasur

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

Cheers
Shasur
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])