Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range("a21") .end(xlDown) or .end(xlUp) . offset(1,0) . value
Can anyone help explain this situation;
When I try this statement: Range("a21").end(xlDown).offset(1,0).value = x the cursor does NOT find the end of the list in column "A" to place the value in the proper cell. When I try this statement Range("a21").end(xlUp).offset(1,0).value = x the cursor DOES find the end of the list in column "A"to place the value in the proper cell. This puzzles me to not end. Thanks for any enlightenment JDB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Destination:=.Cells(.Rows.Count, "A").End(xlUp).Row + 1 | Excel Programming | |||
Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0, | Excel Programming | |||
Cells(Rows.Count, "b").End(xlUp).Row | Excel Programming | |||
inalRow = Range("A65536").End(xlUp).Row | Excel Programming | |||
S1.Range("D65536").End(xlUp).Select | Excel Programming |