| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Array
Hi,
Is it possible to do a "Column Array" so you can copy paste special Column's A, D, Z As Range("A:A,D:D,Z:Z").SELECT Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Does not work -- Message posted via http://www.officekb.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column Array
Try
Columns("A").Value = Columns("A").Value Columns("D").Value = Columns("D").Value Columns("Z").Value = Columns("Z").Value -- HTH Bob "FIRSTROUNDKO via OfficeKB.com" <u15639@uwe wrote in message news:a7430a13612b2@uwe... Hi, Is it possible to do a "Column Array" so you can copy paste special Column's A, D, Z As Range("A:A,D:D,Z:Z").SELECT Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Does not work -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to manipulate an 2D Array into a Column Array? | Excel Discussion (Misc queries) | |||
| Finding a number in a column out of an array in another column | Excel Discussion (Misc queries) | |||
| How do I copy a data from a single column into an array and back into another column? | Excel Programming | |||
| I want to get a value from an array, row 1 and column 1 known. | Excel Worksheet Functions | |||
| calculting stats of column array in 3D array | Excel Programming | |||
Linear Mode
