Excel 2016 - Remove stubborn page break

[Dancarro]

Hi,

I have an issue with a page break on a worksheet and I tried everything to remove but nothing of nothing happens.

I tried Page Layout< Breaks< Remove Page Break (does nothing, the page break lines still there)

I again, tried placing cursor under the page break line and backspace and the step above (nothing again). I also tried to reset All Page Breaks and desperate I tried clear print areas, nothing happens. I still see the page breaks, I think I am going crazy.

Please, any help to solve this will be much appreciated.

Regards,
Dan

 

[MARK858]

Then by the sounds of it you column widths/font size/margins etc. are too big to fit on the one page for your paper size and so you are getting the automatic page breaks.

If that is the case I'm surprised with the below if you set the paper size to A3

changing the paper size nothing happens

If that is what is happening then you need to adjust them.

I delete it and now the page break has gone to the last column in the worksheet.

The above makes it sound like you have data/hidden characters/possibly formatting in cells past those columns.
What does

ActiveSheet.UsedRange.Columns.Count

give you?