Hi,

I use a macro to select a cell. How can I make sure this cell is
positioned as the first cell outside of the frozen panes?

Matt

By "outside of the frozen panes" I assume you mean the cell in top, left
position of the non-frozen area. If so, you can use this line of code to
select that cell...

Cells(ActiveWindow.SplitRow + 1, ActiveWindow.SplitColumn + 1).Select

Rick


"MJKelly" <(E-Mail Removed)> wrote in message
news:a17ccacd-3c7c-4968-b6bc-(E-Mail Removed)...
>
> Hi,
>
> I use a macro to select a cell. How can I make sure this cell is
> positioned as the first cell outside of the frozen panes?
>
> Matt

Rick,

I don't want to select the cell just outside of the frozen pane area,
I want the selected cell (selected by a macro) to become the first
vieweable cell outside of the frozen pane area. In other words, I
want to have a given column of data to be shown and everything to the
left of this column to be hidden behind my frozen pane.

Hope this makes sense?
Matt

Set the ScollColumn property of the ActiveWindow to the column number you
want butted up against the frozen pane. For example...

ActiveWindow.ScrollColumn = ActiveCell.Column

Rick


"MJKelly" <(E-Mail Removed)> wrote in message
news:d8f96f0d-3afc-423e-9335-(E-Mail Removed)...
> Rick,
>
> I don't want to select the cell just outside of the frozen pane area,
> I want the selected cell (selected by a macro) to become the first
> vieweable cell outside of the frozen pane area. In other words, I
> want to have a given column of data to be shown and everything to the
> left of this column to be hidden behind my frozen pane.
>
> Hope this makes sense?
> Matt

Excellent.
Thanks very much.
Matt