Quote:
|
The whole program works good as it stands... but as it stands I return data to sheet 1 address "A7" thru "Z7" every time from sheet 2 row "A3" thru "Z3 ". What I want to do is copy data from sheet 2 (row "A3" thru "Z3 ") to an inserted row above the original copied row on sheet 1....and have the inserted row be the active row.
|
I suspect you get the original row to copy by referencing the active cell and want to do the same to copy back to sheet1.
You're needing to test things to see what happens.
Open a new workbook
Make A1 to A5, 1 thru 5
Select A3 to make it the active cell
Alt+F11 to bring up the VB environment
Ctrl+g to bring up the Immediate window
type in
rows(3).insert shift:=xldown
hit Enter..... is A3 not still the active cell and on the inserted row ?
The active cell can be used to determine the copy, insert and paste.