I wanted to know how can one delete all blank rows & columns using VBA? Suppose in Cell A1 there is data but in other cells with row 1 there is no data. Thus we can say this row is not blank. BUt taking other example suppose there is data in Cell C1, A3, A4. But entire row i.e ROW - 2 is blank. How can one delete all such entire blank rows using VBA. Similarly this apply to columns also.
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
