Date Format Issue

[VbaHell]

Hello one and all

I have a date format issue.
I am using Excel 2003
If i do a manuel Vlookup the answer is dates and they are fine.
If I record this action the macro converts some of the dates to the american format.
I have tried custom formating but this is not working

I know I have not provided any detail but is this a simple issue to resolve

 

[rguy84]

My gut says you can just do a format() somewhere.. Post your macro in [ code ] blocks, and what format you need the date in.

 

[VbaHell]

This is my code, It is crude but I am new to VBA

Workbooks.Open Filename:="C:\tmp\B3XOS.CSV"
Windows("Energy CVI v1.xls").Activate
Sheets("Data").Select
Range("Q6").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-12],B3XOS.CSV!C2:C4,3,FALSE)"
Selection.AutoFill Destination:=Range("Q6:Q1500"), Type:=xlFillDefault
Range("Q6:Q1500").Select
Selection.Copy

Date Format required dd-mm-yy