Displaying active cell in particular position on screen

  • Thread starter Thread starter MJKelly
  • Start date Start date
M

MJKelly

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Postion view 2
ActiveCell on inactive sheet 8
Range variables and Freeze Panes 3
Returned position address on protected sheet 7
Cell Position 2
Positioning a Text Box 1
On-sheet activeX component disables copy/paste 6

Back
Top