I have a form of data which i want to use with a data form. There are certain columns which show the £ but no other signs are used.

When i highlight the required information and click data followed by forum the pound signs are shown in the correct places.

Now basically i have another sheet in the same workbook with a command button which uses VB code. It is commanded to go to the sheet with the information select the range of cells and then call up a data form.

This works fine but the £ has now changed to a $. This problem does not occur on any other symbol????

Is this a bug or a programming error.

Below is my code for the command button

Private Sub CommandButton3_Click()
Application.Goto ActiveWorkbook.Sheets("Sales Orders").Range("A2", "R6")
ActiveWorkbook.Sheets("Sales Orders").ShowDataForm
End Sub

Thanks