Freeze Panes code not working

I am writing a large amount of data from an Access database to a spreadsheet.

I have an area of formatting within the code which sets various Ranges and then I Merge columns, set Interior colours, set Borders, and set Column Widths.

Initially I tried to do this use 'With Selectuion ... End With' but found that the output Merging was very random. So I use this at the top of my formatting code (all objects are dimensioned)

Please Login or Register  to view this content.

Then I do the following:

Please Login or Register  to view this content.

Then the problem code:

Please Login or Register  to view this content.

This just doesn't work properly. The pane freezes on Column E.

I changed the range to G1, H1, A1, B1 etc. and it sys on Coloumn E.

I remmed out the 'ObjSht.Range("F1").Select' line and it made no difference.

I remmed out the 'ObjEXL.ActiveWindow.FreezePanes' line and it didn't freeze the pane (expected).

I've tried omitting 'ObjEXL' and the result is the same.

I'm hours into this and cannot resolve it. Can anybody help please?

Andy

Many thanks. Moving the Freeze Frams code above the Merge Code worked.

Not sure what yopu mean in your second comment - could you give an example of what you mean please.

Thanks Andy

Does this apply to all places that I use .Range?

i.e. with .Merge and .Borders etc?

Andy

No I can't understand it but it did - maybe because I have only one worksheet in play?

Anyway thanks for all your help - I have now fully created the spreadsheet from a table of data with full cell formatting. That part of the app is finished and I can move on now to putting in more data.