Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |