ExcelBanter - row that needs to wait till the next page break befor copying

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - row that needs to wait till the next page break befor copying (https://www.excelbanter.com/excel-discussion-misc-queries/61198-row-needs-wait-till-next-page-break-befor-copying.html)

wil4d

row that needs to wait till the next page break befor copying

I have a Macro that hides and copies visible cells to worksheet 3, but, I
have a certain row that needs to wait till the next page break befor copying
so that I don't have to manually adjust them. Moving them manually takes 25
minutes 2-3 times a day, if there is a way it would really save me.

All times are GMT +1. The time now is 05:22 AM.