I think your spreadsheet design needs looking at. Can you attach a small zipped example workbook with your curent layout & code?
I think your spreadsheet design needs looking at. Can you attach a small zipped example workbook with your curent layout & code?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks for looking at my question. I think that I may have stumbled on to a workable answer with the following:
It actually starts at the third row in my sorted spreadsheet, finds the first cell that has data in column C (my sort data column) goes up one row, and then deletes all of the blank rows that were sorted above my actual data but below my header rows (1,2 & 3).![]()
Range("c3", Range("c3").End(xlDown)).Offset(-1, 0).Select Selection.EntireRow.Delete
Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks