Reply to thread

Message: [QUOTE="prkhan56, post: 6452512"] Hi Jim Thanks once again for your help. The macro runs now but the "Date" column is still having mixed date format..,the original code which I posted did not had this problem. Also a slight problem has occurred because of the following code: With ActiveSheet.Range("A1:E999") .Clear .NumberFormat = "dd/mm/yyyy" End With The above code also changes value (which includes serial numbers) in the range A1:E999... I desire that only column with the Heading "Date" should retain its original format as in the word document. All other figures should be unchanged. Rashid Khan [/QUOTE]