Simple Macro Works for Me but 1004 Error for User

**snapfade** · 06-06-2013, 01:49 PM

The macro below simply adds a page break when data changes. It works beautifully on my Windows 8 with Excel365 (it was developed initially in Excel 2010). But a user many miles away gets a 1004 error with his Excel2007 system. I attempted to research 1004 but it seems to be one of those error messages that means different things in different places and I am clueless about what it might mean in this instance.

Can anybody shed some light on what may be wrong on the user's end?

Please Login or Register  to view this content.

Thanks in advance for any suggestions!

**Jakobshavn** · 06-06-2013, 08:09 PM

Give this a try:

Please Login or Register  to view this content.

The lines I had to change were:

LastRow = Cells(Rows.Count, 2).End(xlUp).Row
and
ActiveSheet.HPageBreaks.Add Before:=Cells(x, Col)

**snapfade** · 06-07-2013, 12:43 PM

Hi Jakobshavn,

Thanks for your input. I will give it to the end user to see if it helps. Would you kindly provide a few words of explanation? What do these changes do that the original code did not?

Thanks,
tom

**Jakobshavn** · 06-07-2013, 01:38 PM

The change to LastRow is necessary because we want to locate the last row, not count the number of rows in UsedRange.
The change to the HPageBreaks worked on my computer.