- How can I copy paste cell values only?

[Don Guillett]

As always, post YOUR macro for comments.
rng.value=rng.value

 

[Don Guillett]

Use Paste PasteSpecial (look in HELP)

 

[S>B>S]

I have a macro that manipulates excel data copy-pasted from several Excel
2000 documents. Is there a way to make sure that Selection.Copy copies just
cell values ignoring all other cell properties (formulas, formatting,...)?

 

[S>B>S]

Workbooks.Open("c:\SourceFile1.xls")
Workbooks.Open("c:\SourceFile2.xls")
Workbooks.Open("c:\SourceFile3.xls")

Workbooks.Add

Workbooks(1).Worksheets(1).Range("F3:AC38").Copy
Workbooks(4).Worksheets(1).Paste

Workbooks(2).Worksheets(1).Range("F39:AC76").Copy
Workbooks(4).Worksheets(2).Paste

Workbooks(3).Worksheets(1).Range("F77:AC115").Copy
Workbooks(4).Worksheets(3).Paste

How can the above be modified so that Range.Copy picks up just the values of
selected cells?

 

[S>B>S]

Thanks. Help did help

Use Paste PasteSpecial (look in HELP)

--
Don Guillett
SalesAid Software
(e-mail address removed)
values