I am trying to make a macro that sets up a worksheet for printing. I need to know how to set the vertical page break between (EXAMPLE) columns J and K. Or alternatively , set it on the right side of the set printing area. What is the VB command to do this?
Note 1: I actually need to set the first vertical page break between columns "J" and "K". Not make a new vertical page break, but set the first vertical page break.
Note 2: I orginally set it up so it switched to a printing view, then grabs the vertical page break and pulls it over a couple of columns. But sometimes that pulls the break outside the printing area and causes the macro to error.
Bookmarks