Macro&SplitScreenProblem
 

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

Macro&SplitScreenProblem
 

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

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