troubleshooting Question

Excel 2007 Rows Will Not Delete Manually or with VBA

Avatar of RobStl
RobStlFlag for United States of America asked on
Microsoft Excel
18 Comments1 Solution360 ViewsLast Modified:
Hey experts,

Note: I am using Excel 2007.  I have a spreadsheet that I import, which currently contains 65536 rows (max rows in Excel 2003?).  The spreadsheet is an .xls file, and only contains data in the first ~1000 rows.  New data gets added to the spreadsheet each week, so the rows of data will continually grow, but should never grow more than 2000 rows total.

My issue is that the spreadsheet contains 65536 rows total, but data is only in the first ~1000 rows.  I have tried to manually delete the rows that do not contain data, as well as deleting them via VBA.  Either way, the rows do not get deleted... It's like there is a lock on the total number of rows, declaring that there must be 65536 rows at all times.  Could someone enlighten me on this?

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 18 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros