This should be a simple fix for you guys!
After i go "xlDown", how do i maintain the same cell range in the C
column when i move over one column? In Excel, i would do the
following... in Starting in D6... Ctrl+Shft+Dwn, Shft+Left+Tab+Lft
how do i translate into code?


eg. "xlDown" in the below code highlights D6:D?... Now i want the same
range highlighted in column C =, not D.


Range("D6").Select
Range(Selection, Selection.End(xlDown)).Select
Range("C6:C1260").Select

ExcelJockey

*** Sent via Developersdex http://www.developersdex.com ***