Hi all.

I have a similar issue to a question that can be found in this thread, and it is the closest to answer I've been able to find through using google.

I have the same issue in that I have created my XSD file and pulled it in to Excel. When I manually drag it on to the cell I want it applies the XSD across all columns and rows and I can then export the XML. The problem is a I have no idea how to use this in a macro. I 've looked at the thread above and used the solution and googled ListColumn.XPath.SetValue syntax which the thread opener used as solution but I just can't get it working.

Is someone able to very kindly just show me what the syntax should look like if I'm applying to sheet A Cell B1 and then I can adapt it to use on all sheets in the workbook.

thanks very much.