Hi,

Have you tried this :

Range("A4").Style="Workbooks("FileName.xla").Style ("myStyle")



"Dreiding" a écrit dans le message de groupe de
discussion : ...
I've created an Add-in to add a worksheet based on user inputs from a form.
I use custom style definitions (i.e. Range("A4").Style="myStyle") in my
Add-in.
Unfortunately Excel errors when trying to execute the code.

Is there a way to access the styles defined in the Add-in?

Thanks,
- Pat