| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
range pick
Range(Target.Offset(0, -7), Target.Offset(7, 0)).Copy _
Can the code be changed to omit 6&7 this copies column ABCDEFGH I would like to omit FG H is the start Thanks All |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
range pick
/either do it in two steps or create a range which is a union of two ranges.
Union( Range(Target.Offset(0, -7), Target.Offset(7, -3)),range(target)).copy If target is already a range then Union( Range(Target.Offset(0, -7), Target.Offset(7, -3)),target).copy "Curt" wrote: Range(Target.Offset(0, -7), Target.Offset(7, 0)).Copy _ Can the code be changed to omit 6&7 this copies column ABCDEFGH I would like to omit FG H is the start Thanks All |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #2: VBA to Pick Range and letter | Excel Discussion (Misc queries) | |||
| #2: VBA to Pick Range and letter | Excel Worksheet Functions | |||
| #2: VBA to Pick Range and letter | Excel Programming | |||
| loop through cells in a range and pick up corresponding cell values in another range | Excel Programming | |||
| how to pick from a range of table values | Excel Worksheet Functions | |||
Linear Mode
