Changing the global currency symbol

What is the number format in the workbook's Normal Style (Format|Style)?

Andrew

Thank you, that has fixed it.

If it happens on all workbooks you create, you will need to change it in your Book.xlt template.

http://office.microsoft.com/en-gb/excel-help/about-excel-templates-HP005229286.aspx

Re: Copying data from one workbook to another using VBA

Hi

I am a newbie to VBA and struggling. I want to simply copy data from a cell in one workbook to a cell in another workbook but keep getting the error 'Run-time error 9': Subscript out of range. Can some kind soul please tell me what I am doing wrong? I have the following code in a module:

Sub CurrentBalance()
Dim WBcopy As Workbook
Dim WScopy As Worksheet

Dim WBpaste As Workbook
Dim WSpaste As Worksheet

Set WBcopy = Application.Workbooks("C:\Users\John\Documents\Spreadsheets\.....")
Set WScopy = WBcopy.Worksheets("Sheet 1")

Set WBpaste = Application.Workbooks("C:\Users\John\Documents\Spreadsheets\....")
Set WSpaste = WBpaste.Worksheets("Sheet 2")

WScopy.Range("I598").Copy
WSpaste.Range("Y2").PasteSpecial (xlPasteValues)
End Sub

sorry, this was supposed to be a new topic. I don't know how to delete it and start again.