I have a spreadsheet that is constantly changing size. It can grow or shrink. Column A to P only but the rows will be based on only the rows with data. Stop selecting them when they are empty.
Also Row 1 and 2 are Headers and I do not want them selected as print area. I will be selecting Row 2 to repeat at the Top every time. I do not know if I can include that in the macro to make sure it is done every time.
I have asked several people to help me with this but every time I have problems. This is for Excel 2000, maybe that is the problem. I can send you the spreadsheet if it helps. The Tab that I perform the macro on will also be changing week by week, so the macro cannot be linked to a specific page or tab. I am not good with macros so need all the help I can get.
Bookmarks