Now I need to convert the following sort to one that will work for Excel 2003. I commented out the code below and the macro ran fine. Upon trying to run the macro, I got a Run Time Error '438' - object doesn't support this property or method. I thought the code I was using was compatible with both versions. I was aware to be cautious about the conflict and tried to eliminate as much as I could by using a 2003 version spreadsheet (.xls file) and I have tried to make sure the number of rows called out in the code do not go above the max for 2003. I run Excel 2007 and have code that works perfectly with that version but just found out it will not work with Excel 2003.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |