Macro&SplitScreenProblem
Thanks, the "freeze panes" works great.
--
mike
"Toppers" wrote:
Hi,
Could you not use "Freeze Panes" to keep the headers displayed?
I have tested your condition (as far I understand it) and the copy works OK
with split screens.
XL2003
"mike" wrote:
I have a problem that I hope someone can help.
I hava a macro that copies data from another spreadsheet into column a,b,&c
of a master spreasheet. Each time the macro is acitvated, the data is
copied onto the next row, a2,b2,c3, a3,b3,c3 etc.
The first row, cell a,b & c contain header names for the data in the
column. The Macro works great unless I use a split screen on the second row
a2. Once I do this, the macro copies data in the wrong cells and is useless.
The split screen is helpful to view the column headers and I would like to
use it if possible.
thanks for any assistance
mike
|