Thread: delete row
View Single Post
 
Old 10-04-2012, 11:14 PM
tomlam tomlam is offline Windows 7 64bit Office 2007
Advanced Beginner
  
Join Date: Oct 2012
Posts: 33
tomlam is on a distinguished road
Default
that is part of the excel vba programe,

Code:
lastRow = Cells(Rows.Count, 1).End(xlUp).Row
For Z = 2 To lastRow
  If (Cells(Z, ("f"))) = "" Then Cells(Z, ("f")).EntireRow.Clear
Next Z
then so there will some empty row, so we dont how to write to vba as
my request as previous enquiry

Thanks Macropod
Last edited by macropod; 10-04-2012 at 11:50 PM. Reason: Added code tags & formatting
Reply With Quote