I have two tables in one spreadsheet, directly below each other -
different column headings for each. I'm wanting the frozen panes for
the column headings to change as I scroll down to the second table.

An If statement specifying the heading may be entered, referenced to a
cell that dispays the number of times i've clicked down - by how do I
do that?

Thanking you in advance for any input...

I don't think there is a way to catch the scrolling events, so no way to
know when your scroll window has moved to the second table.

What I can suggest is using two windows stacked on top of each other.
From the Window menu, select 'New Window'.
Freeze each of their panes for the column header.

Then run the Windows.Arrange method to horizontally synchronise them. When
one scrolls right, the other does too!

Sub test()
Windows.Arrange ArrangeStyle:=xlArrangeStyleHorizontal, _
ActiveWorkbook:=True, SyncHorizontal:=True
End Sub


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Matthew Turinski" wrote in message
m...
I have two tables in one spreadsheet, directly below each other -
different column headings for each. I'm wanting the frozen panes for
the column headings to change as I scroll down to the second table.

An If statement specifying the heading may be entered, referenced to a
cell that dispays the number of times i've clicked down - by how do I
do that?

Thanking you in advance for any input...

(Matthew Turinski) wrote in message om...
I have two tables in one spreadsheet, directly below each other -
different column headings for each. I'm wanting the frozen panes for
the column headings to change as I scroll down to the second table.

An If statement specifying the heading may be entered, referenced to a
cell that dispays the number of times i've clicked down - by how do I
do that?

Thanking you in advance for any input...

Thanks to Rob for the help - the new window works for the spreadsheets
that only have a couple of tables below, but for 3 or more, there are
too many on one page...there must be another way!!

You could add your own slider control or up/down button which hides/unhides
rows as needed.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Matthew Turinski" wrote in message
m...
(Matthew Turinski) wrote in message
om...
I have two tables in one spreadsheet, directly below each other -
different column headings for each. I'm wanting the frozen panes for
the column headings to change as I scroll down to the second table.

An If statement specifying the heading may be entered, referenced to a
cell that dispays the number of times i've clicked down - by how do I
do that?

Thanking you in advance for any input...

Thanks to Rob for the help - the new window works for the spreadsheets
that only have a couple of tables below, but for 3 or more, there are
too many on one page...there must be another way!!