delete row

		Microsoft Office Forums > Microsoft Excel > Excel Programming
delete row

10-04-2012, 11:14 PM

tomlam

Windows 7 64bit delete row

Office 2007

Advanced Beginner

Join Date: Oct 2012

Posts: 33

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete Space	mariadanmark	Excel	2	05-17-2012 02:53 AM
cannot delete these lines!	userman	Word	4	05-02-2012 12:34 AM
Delete option greyed out when trying to delete row 1	tpcervelo	Excel	2	11-15-2011 06:48 AM
Cannot delete folders	klingenfelter	Outlook	10	02-04-2011 01:35 PM
delete email message via blackberry and have it delete on my pop3 and my outlook	Iamthestorm	Outlook	2	10-28-2010 12:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:11 PM.