LinkBack URL
About LinkBacks
I designed this code on Excel 2007 and when I upgraded to 2010, it no longer works. It deletes everything except the header row. Any help would be appreciated.
Please Login or Register to view this content.
I designed this code on Excel 2007 and when I upgraded to 2010, it no longer works. It deletes everything except the header row. Any help would be appreciated.
Please Login or Register to view this content.
Testing it in Excel 2010, it seems that the first 2 lines of code (Attribute...) are wrong. I commented them and it seems to work. At least, the process goes through the lines of code smoothly.
Yea, I can get it to run through the code smoothly, but it deletes all the contents of the cells, except the header row. I was thinking it might be something with the line that specifies format type for the time/date field.
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
Doing this will ensure you get the result you need!
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Do you want to delete the cells that contain 10:00:00 AM or the rows that contain 10:00:00 AM in column C ?
I would delete those cells/rows before sorting.
And specify the sheet in which this takes place.
Please Login or Register to view this content.
No, I want it to delete all rows except the ones containing 10:00:00 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks