Macros and Freeze Frame problem

[ironsides]

I have several macros and a freeze frame line between lines 3 and 4 in an Excel sheet. The macro buttons are across lines 1 and 2. When I activate a macro having 2 or 3 sorts the freeze frame line disappears and the data moves up to line 1 and 2 under the buttons. Did I do something wrong. How can I fix this?

 

[Tom Urtis]

The answer might lie in the code itself, if it involves unfreezing the pane, or deleting rows, or who knows what. If you are unfamiliar with VBA code, try posting the macro code and a description of what should occupy rows 1, 2, 3, and 4 before and after the macro runs. Hard to tell from a distance without knowing a few more details.

 

[Fryer Tuck]

I agree w/ Tom, its hard to tell without eyeballing the code. However, it sounds like you dont have data in the first to rows, but the sort includes those rows. (I assume this on your saying that data winds up in those rows.) Try limiting your sort to starting with row 3.

F.T.