You're welcome, glad I could help.
John
"Martin C" wrote in message
...
Hi John
Thanks I run excell 2007 but with your ref to R1C1 reference Style I
managed to put things right
Many thanks
Martin
"John" wrote:
Hi Martin
In Excel 2003 and older goto ToolsOptionsSelect General Taband unselect
R1C1 reference Style.
HTH
John
"Martin C" <Martin wrote in message
...