vb selection problem
Posted by Stephanie on July 05, 2001 4:10 PM
I want to select worksheet "PVData" in Excel, copy it, and paste as values.
If I just needed to do this in Excel rather than from a macro I would do ctrl+a, ctrl+c, alt+e, s, v, enter
This is what I've been playing with, but I'm a beginner with vb and can't get it to work!
Sheets("PVData").Select
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Any ideas on how to do this selection stuff properly?