View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JDB[_2_] JDB[_2_] is offline
external usenet poster
 
Posts: 15
Default 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