Hi All

Just wondering if anyone can shed any light on this........

I have the follwing code (below) which runs fine on my machine (Vista and Excel 2010) but when the client runs the code on their machine (XP and Excel 2003) it falls over on the HPageBreaks line. It just seems very strange to me that it works on VPageBreaks but not on HPageBreaks.

The error they get is "Run Time error ’9’ – subscript out of range"

Please Login or Register  to view this content.


I have read some items on the internet where it suggests that the active cell may have something to do with it but I dont know if that is correct because as mentioned it works for me.

Any advice would be great.

Thanks very much

Jim