Problem with formatting

[Hashiru]

Can any one help please.
I am having problem formating my code. I want the code to format each additional cell by clearing any format in that cell and place the desired form.

Desired format: 01/01/2011 "dd/mm/yyyy"

My code:

With Worksheets("Bank Payment").Cells(7, 1).Resize(nextrow, 1)
.Clear
.NumberFormat = "dd/MM/yyyy"
End With

nextrow is a variable that change each time an entry is made


I want to type 01/01/11 and the code format it to 01/01/2011

thanks

 

[Hashiru]

Thanks GlennUk it works and it is the best as my method used two lines of code to get your one short line of code
Bravo

 

[GlennUK]

That's great!