Hi,
i have a problem with the deletion of an empty row in Excel.
My code:
If $vRow_2 = "" Then
_Excel_RangeDelete($oWorkbook_1.ActiveSheet,"2", $xlShiftUp,1)
EndIf
I want to delete the second row. $vRow_2 is an empty cell, "A2".
After running the code, the second row is not deleted.
I have tried also:
If $vRow_2 = Null Then
_Excel_RangeDelete($oWorkbook_1.ActiveSheet,"2", $xlShiftUp,1)
EndIf
But it doesn't work.
Any suggestion?
Thanks in advance.