Macro Print Range Problem - Rows Cut Off (Upgraded From Excel 2003 to2007)

A

ac1179

I just upgraded from Excel 2003 to excel 2007. One of my workbooks has
the following
macros, which prints the Range V4:AP88. When i was using Excel 2003
this printed to two pages. Now in Excel 2007, it still prints to two
pages, but rows 64 to 88 get cut off.

I played around in pagebreak view. After selecting the entire range
V4:AP88 and setting this as the print area, I noticed a dotted line
between rows 63 and 64. When I try to drag
the dotted line to row 88, it doesn't allow me to.

Is there a reason why this happens? I noticed when I reset all page
breaks, I was able to
adjust the "dotted" lines.

I have over 20 macros similar to the one below. I'm hoping I don't
need to rewrite all the macros. Does anyone know if there's an
alternative? If not, how should i modify this macro?

Sub TCTREND_P()
Application.ScreenUpdating = False
Application.Goto reference:="TCTREND" '****This is range
V4:AP88*******
ActiveSheet.PageSetup.PrintTitleRows = "$4:$12"
Selection.PrintOut Copies:=1
ActiveSheet.PageSetup.PrintTitleRows = ""
Sheets("PRINTMENU").Select
Application.ScreenUpdating = True
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need a macro to set the print range only for visible rows 1
Problem w/ Print Macro 3
Can you hide and unhide rows with a macro based on content of colu 4
Porting from Excel 2003 to Excel 2010 12
Private vs. Public VB problem in Excel 2007 2
Excel 2007 macro conflicts with excel 2003 5
Macro for deleting rows 1
Delete empty rows with macro by John Walkenbach 2

Top