row values = vbNullString

[matrixknow]

I have a delete empty row function. This works fine ! little modification is necessary. Now he delete a line when the first cell is empty. He should verify the values of a row or at least a range. I tried rows(i4Row), not working.

Please Login or Register  to view this content.

[royUK]

Use COUNTA to see if any cells in the row have a value. Something like

Please Login or Register  to view this content.

[matrixknow]

Hi roy,

its a nice proposal, thanks. He delete the empty rows but finally he crashed.
error "Method range failed". Any id ?

[mudraker]

either mothod should work without error

One possible problem is that i4row looks like an Interger type variable & lLR looks like a Long type variable
Suggest change i4Row to l4Row & declare it as

Please Login or Register  to view this content.