Pasting Values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sammy2x - 30 Dec 2005 12:02 GMT

Hi,

I have developed a quoting tool which creates an output sheet detailing
all the info, What I would like to be able to do is take a copy of this
and paste the values (and Format to a new workbook). I'm currently
doing this manually and I unsure how to automate it!

I have never used VB which I'm guessing is the only way of doing it, so
please be gentle!!

Thanks,

Sam.

Signature

sammy2x

Reply to this Message

Dave Peterson - 30 Dec 2005 14:44 GMT

Try recording a macro when you select that output sheet.
Then edit|move or copy sheet (select copy and copy to a new workbook)
Then select all the cells on that new sheet.
edit|copy
Edit|paste special|Values

I got something that looked like:

Option Explicit
Sub Macro1()
Sheets("Sheet2").Select
Sheets("Sheet2").Copy
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End Sub

> Hi,
>
[quoted text clipped - 15 lines]
> sammy2x's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29674
> View this thread: http://www.excelforum.com/showthread.php?threadid=496906

Signature

Dave Peterson

Reply to this Message