Insert Page Breaks code different in Excel 2007 and 2010?

**Iswarya** · 04-20-2010, 02:33 AM

I have a snippet of VBA code where I insert a page break at a particular row. This works perfectly fine for me in one machine(where I have Excel 2007), but in another machine the same code doesn't insert a page break. It sounds weird to me that VBA would behave differently with different versions of Excel. Am I missing something else here?

**romperstomper** · 04-20-2010, 02:54 AM

What is the code (and please use code tags when posting it) and does it cause an error on the 2010 machine, or just not do anything? (do you have a default printer installed on the 2010 machine?)

**Iswarya** · 04-21-2010, 02:09 AM

This is the snippet of code I have.

Set ActiveSheet.HPageBreaks(2).Location = Range("A157")

The same code works perfectly fine on a 2007 machine I have and inserts a page break.But when I try running it on 2010, I don't get an error. It simply doesn't do anything.

And I'm sorry I didn't get what you said - did you mean add the word "code" to tags?

**teylyn** · 04-21-2010, 02:56 AM

Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

**romperstomper** · 04-21-2010, 08:59 AM

I've just run some tests in 2010 (probably not the version you have though) and I simply get an error every time I try to change the Location property like that. Which is odd. Of course, it may have been fixed in the final version.