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.