I am using office 2003
I recorded a macro to open my master wb, copy an entire sheet and
pastespecial to a blank sheet inserted in another workbook.
The problem is when I run the macro I get a dialog box giving me the
choice of pasting unicode text or just text. I chose Unicode Text - but
that did not paste my formatting or my formulas.

Here is the macro:
Sub GetMstrInfo()
Workbooks.Open Filename:="C:\Pricing\TestJoes\TestMaster.xls"
Sheets("Tr-Vul").Select
Range("A1:K32").Select
Range("A2").Activate
Selection.Copy
ActiveWindow.Close
Sheets.Add
ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, _
DisplayAsIcon:=False
End Sub

Could someone please tell me how to adapt this macro so that my new
worksheet has all the formulas and the formatting as the worksheet I am
copying from? I see PasteSpecial Format:="Unicode Text", but I don't
know how to change that statement to get what i need.

TIA
Joanne