- Feb 5, 2006
- Office Version
Good day. I am running Excel out of Office365 (updated) on Windows 10 Home. I have a worksheet that contains 4550 songs with 8 Columns in each Row. Row 1 contains Headers for the Columns. One of the Columns is named "Title" and another is "Year". I wrote a Macro to sort the entire worksheet by Year first and then by Title. It worked, but in looking at the Macro code, the last Row is identified as 4552 which is one more row than there is data. Then I wrote a second Macro to sort the entire worksheet back to Title only. That code showed the last Row as 4553. The sorts are fine and the extra blank Rows at the bottom are no problem. Is it normal for this to happen? If I end up writing any more Macros to sort the worksheet, will the last row keep adding a blank line? If I execute a Control End, the cursor ends up in Column H of the last Row (either 4552 or 4553). Thanks for any help.