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?



Posted by Scott S on July 05, 2001 5:33 PM

Where do you want the data to be pasted?