Prev: Converting strings to numbers
Next: Macro that searches for keyword and replaces it with ...
From: FIRSTROUNDKO via OfficeKB.com on 29 Apr 2010 12:10
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

From: Bob Phillips on 29 Apr 2010 12:33
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(a)uwe> wrote in message
news:a7430a13612b2(a)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
>


 | 
Pages: 1
Prev: Converting strings to numbers
Next: Macro that searches for keyword and replaces it with ...