Record a macro that...
Ctrl+Home (to get to cell A1)
Insert--Row
Type the headings.
Stop recording.
I'm not sure why it might be any more difficult than that.
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"jonesaa05" wrote
in message ...

Sorry, I should clarify that the values are copied from different
sheets into one sheet using macro.

Only certain related cells are copied, so I have to add title in the
columns myself. So, what I mean is after the values are copied (run the
macro), can I also add title for each columns as well. I don't want to
type in manually. Is there any ways to do this?


Thankyou.

amy


--
jonesaa05
------------------------------------------------------------------------
jonesaa05's Profile:
http://www.excelforum.com/member.php...o&userid=28021
View this thread: http://www.excelforum.com/showthread...hreadid=477044