Hi

Record a macro where you format the sheet as desired, then incorporate
the recorded code in your own code.

Regards,

Per

On 29 Dec., 00:39, Mekinnik
wrote:
Is it possible and how do you format a sheet programmaticlly in VBA. I would
like to format a newly created sheet once the data is copied or when the data
is copied from another sheet. I would like to format the new sheets with
borders and header rows with bold names to match the coorisponding data in
that column.