Dear Vinod, You are welcome...!!
Solving query and Posting query, both are meant for learning enhancement. So
no worries.. :)
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 1/24/10, Vinod N w
Thanks Dave and Dilip Solution is as per my requirement
Anil: I'm at present deleting blank rows using filters... and was check with
the group for a better alternative Thanks a lot for your concern
Indeed its a pleasure to be a part of this group.. Eventhough I did not
reply/solve
Dear Vinod,
Below is what I have written today for some other group member, you can use
this.
First set is for Row and second set is for Column. If you search within my
replies for today, you can find the attached workbook also.
Sub delR&C()
Cells(1, 1).Select
For n = 1 To Range("a65536").End(xl
selected.")
Cells(Selection.Row, 1).Select
End If
End If
End Sub
If you are using XL2007, you'll have to change the Columns count.
Regards - Dave.
From: nvino...@gmail.com
Date: Fri, 22 Jan 2010 11:26:34 +0530
Subject: $$Excel-Macros$$ Delete rows only if the entire row is empt
Dear Gurus,
Macro or any other way in excel where the user should be able to delete rows
only if the entire row is empty...
Please help...
--
Thanks and Regards
Vinod N
--
--
Some important links for excel users: