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