| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Want code to copy to ABOVE row 22 column A on sheet 1
This portion of code works just fine to copy to sheet 1 EXCEPT it sees the permanent data in A22:Z22 and copies very nicely BELOW that data in row 22. Set nRow = Sheets("Sheet1").Cells(Rows.Count, "A21").End(xlUp) If nRow.Value = "" Then Range("A1:Z4").Copy nRow Range("A1:Z4").ClearContents ElseIf nRow.Value < "" Then Range("A1:Z4").Copy nRow.Offset(3, 0) Range("A1:Z4").ClearContents End If I modified this line, which worked fine on a different sheet, to copy to Sheet1 above row A22. On the other sheet, column AC is 'clean' from top to bottom. Apparently it does not recognize the 21 with the column A and copies below the existing data in A22:Z22. Set nRow = Cells(Rows.Count, "AC").End(xlUp) How do I make start from A21 and go up from there on sheet 1? Thanks, Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to copy column in sheet 1 to column in sheet 2 based on matched criteria | Excel Programming | |||
| Help to code Macro to Copy fron one sheet and paste in other sheet | Excel Programming | |||
| VB code to copy sheet format to another sheet | Excel Discussion (Misc queries) | |||
| how to make one column copy from one sheet to anoth column w/o zer | Excel Discussion (Misc queries) | |||
| How do i copy a active sheet to a new sheet with code and everything | Excel Programming | |||
Threaded Mode
