search header name from list and find it in another sheet change dd/mm/yyyy format

[baskar5353]

hi,

i'm having "header" list in one sheets. i want to find the header which i have in "header" sheets find in another sheets and want to change the format as dd/mm/yyyy. how to do it in VBA

 

[chirayu]

Sample workbook attached

Sub Macro1()

Dim Val As String

Val = Worksheets("Sheet1").Range("B1")

Worksheets("Sheet2").Select
Cells.Find(What:=Val, LookIn:=xlFormulas, LookAt:=xlWhole).Activate
ActiveCell.EntireColumn.NumberFormat = "DD/MM/YYYY"

End Sub

 

[baskar5353]

i'm having header list in separate sheet from that sheet based on header i want change dd/mm/yyyy.

 

[Marc L]

Hi !

Before to log in, when you enter this site forums,
read the second advice within the rollin' banner !
​