Hi all,



Is there any way to limit the amount of columns in a workbook or sheet. Currently when you get to Z it then goes onto AA AB etc ideally I would like the sheet to stop at Z as I am trying to name a cell AA2 but as you can appreciate there is already a cell called AA2 so Excel takes me to that rather than letteing me name it as below

http://imageshack.us/f/16/97253990.jpg/

Why would you want to call a cell "AA2"?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

We have a 3rd party application which links to MS Office and populates information externally. The link is derived from the cell name matching a variable in the 3rd party app.