![]() |
|
#1
|
|||
|
|||
|
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/ |
|
#2
|
||||
|
||||
|
Why would you want to call a cell "AA2"?
__________________
Using O365 v2503 - 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 |
|
#3
|
|||
|
|||
|
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.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Exporting workbook specific sheet columns on exit
|
shabbaranks | Excel Programming | 4 | 08-21-2012 08:00 AM |
| sheet 2 data highlight in sheet 1 | gsrikanth | Excel | 1 | 04-21-2012 06:25 PM |
Construct a summary sheet by summing up from one or more than one sheet.
|
PRADEEPB270 | Excel | 1 | 11-04-2011 03:46 AM |
| copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |
Compare data in different columns in an Excel sheet
|
kgfendi | Excel | 5 | 05-16-2009 05:42 PM |