VBA to copy paste header from specific column

[Abhishekghorpade]

Hi

I want to Copy & Paste the following headers starting with the first date field (new column H) with macros.
[TABLE="width: 734"]
<tbody>[TR]
[TD]DoB
[/TD]
[TD]DoH
[/TD]
[TD]Entry Date
[/TD]
[TD]Term Date
[/TD]
[TD]Disable Date
[/TD]
[TD]Death Date
[/TD]
[TD]Officer Staus Cd
[/TD]
[TD]Own%
[/TD]
[TD]YTD OverrideHrs
[/TD]
[TD]SrceLev Elig OptCd
[/TD]
[TD]Div
[/TD]
[TD]Term
[/TD]
[TD]Rehire
[/TD]
[/TR]
</tbody>[/TABLE]

can anyone help me with that

 

[Joe4]

If you turn on your Macro Recorder and record yourself manually copying the cells you want to copy, that may give you the code that you need.
If it does not, please explain the details of exactly what you want to happen (be specific, in using column/sheet references, etc).

 

[Abhishekghorpade]

I just figured out the way to do it.. Thank you so much for your time