| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Offset
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 *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OFFSET COLUMN() ROW() - what does this mean? | Excel Worksheet Functions | |||
| offset row not column | Excel Programming | |||
| Countif from an offset column | Excel Worksheet Functions | |||
| Offset from a variable column to a fixed column | Excel Programming | |||
| offset every nth column | Excel Worksheet Functions | |||
Threaded Mode
