Column Array

  • Thread starter FIRSTROUNDKO via OfficeKB.com
  • Start date
F

FIRSTROUNDKO via OfficeKB.com

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
 
B

Bob Phillips

Try

Columns("A").Value = Columns("A").Value
Columns("D").Value = Columns("D").Value
Columns("Z").Value = Columns("Z").Value
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help merging two VBA codes 2
Macro Related to Paste Values 2
Having difficulty copying and pasting on VBA 3
lenghty code 4
Copy and paste range ontime 2
in VBA script, make cell values = formula value, not formula 2
range loop? help 2
Copying Solver results of each iteration to a given location in a workbook 1

Top