CopySheet / Format

[leeparvin]

Hi there

I have a sheet/tab on a spreadsheet called 'Template', which contains a number of formated cells ie bold, merged etc

Im wanting to create new worksheets / tabs using this 'Template' sheet.

Using CopySheet(Template.Index,NewSheet.Index) copies the cell contents but not the formatting.

What am I doing wrong?

Thanks

Lee

[leeparvin]

Hi there

Please ignore my previous issue as Ive resolved it. It was a problem on the source 'Template' tab and nothing to do with the VCL.

My mistake - sorry

Cheers

Lee