Hi Rain,
Please extend amd post the excerpt to include your.preceding selection and
copy steps.
---
Regards,
Norman
"Rain" wrote in message
...
Hi Norman,
Thanks for the reply. Is there any way to write these lines in a similar
way ?
excerpt:
Application.CutCopyMode = False
Selection.Insert shift:=xlToRight
Selection.NumberFormat = "dd/mm/yyyy;@"
<<<
Regards,
Rain
|