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
|