Hi,
I once solved this problem, but when I solved it, I didn't have frozen panes involved in my sheet.
I'm trying to use this code:
and I also have code that does the same thing, but searches for a 'y'Please Login or Register to view this content.
Please Login or Register to view this content.
When I press this button, it removes everything from the table and pastes it into the other sheet with about 10 blank lines above the entires. Also, it messes with the frozen panes from the previous sheet (once frozen at row 9, press button, becomes frozen at row 6).
I have attached my workbook
the password, when prompted, is "MillSteel"
Please Help!
Bookmarks