Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Mona Mehta   on Mar 02 In MS Office Category.

  
Question Answered By: Julio Morgan   on Mar 02

I am not using the auto filter on this sheet,
nor "Input Bozes". In Excel, you can draw things  using the draw
tools (autoshapes, lines , arrows, "Text Boxes", etc). There is
usually a button dedicated to text boxes at the bottom of the Excel
window if you have Draw Tools shown. One looks like a small page
with an "A" and some lines. With this you draw a box and type some
text into it, color it, border it, etc. I made text boxes at the top
of the columns which I wanted sorted and then linked the text boxes
to the respective macros....However, I believe this is unrelated to
my current problem.

With only one pane in the window, I get correct cell  references into
my macro  and all works as expected.

When I split the window into two panes (L/R), my "ActiveCell"
references do not return  the correct cell reference (location). I
only get the last selected  cell in the *left pane* even if a cell in
the right pane *IS* selected (when the macro is entered).
Two more symptoms:
1- If I select a left  pane cell and "arrow" to the right (selecting
cells to the right), moving the selected cell into the area currently
covered by the right pane (also causing the left pane to
automatically scroll  to the right - you now see the selected cell in
poth panes since they cover common areas), THEN my macro gets the
correct cell reference.
2- If I "Freeze" the window panes, then I appear to always get the
correct cell referenced into the macro - regardless whether it is in
the left or right pane.
I see a "Panes" object or method (I can't tell the difference just
yet) AND have been able to write a statement which returns a value
(in the immediate window via a Debug.Pring statement) showing how
many panes are open (1, 2, or 4), but do not know what I need to do
(other than freezing the window) to always get a correct cell
reference regardless of which pane it happens to be visible in.

Share: 

 

This Question has 9 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Retain cell selection through sort Or get search suggestion and latest updates.


Tagged: