We are being pursuaded to move into Excel 2007, I can barely control my excitement.
I am experiencing some compatibility issues running 2003 code in 2007, so I may be here quite often
Code: Select all
Set ActiveSheet.HPageBreaks(1).Location = Range("A71")
Ideally, I need to be able to execute the same code in both 2003 & 2007.
Also:
Code: Select all
Rows("227:65536").Delete Shift:=xlUp
Thanks in advance.