Can Excel find the last row on a PAGE?
Posted by Paul B on January 31, 2002 3:57 AM
I have a list in Excel in columns A, B ,C, D, about 250 rows, I am taking the rows at the start of page two and move them to columns F,G,H,I, leaving column E between them, to fill up the page, and then take what is left and do the same thing so it will fit on page two. I am currently using a Marco to do the cutting , pasting, deleting rows, then cutting, pasting again what is left to accomplish this, but I have to put in where the last row on the page is and where the first row on the next page will be, this changes if the margins change or the rows expand because of text wrapping, is there a way in Excel something like the way to find the last row, range(A65536).End(xlup).row, to find the last row and the first row ON A PAGE? If so how? Thanks to all who take the time to help out on this board, it is a real help to the people trying to learn Excel and VBA. I am using Excel 97