Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-11-2012, 01:16 AM
shabbaranks shabbaranks is offline Removing columns within sheet Windows 7 64bit Removing columns within sheet Office 2007
Advanced Beginner
Removing columns within sheet
 
Join Date: Mar 2011
Posts: 89
shabbaranks is on a distinguished road
Default Removing columns within sheet

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/
Reply With Quote
  #2  
Old 09-11-2012, 04:49 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Removing columns within sheet Windows 7 64bit Removing columns within sheet Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,577
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

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
Reply With Quote
  #3  
Old 09-11-2012, 05:03 AM
shabbaranks shabbaranks is offline Removing columns within sheet Windows 7 64bit Removing columns within sheet Office 2007
Advanced Beginner
Removing columns within sheet
 
Join Date: Mar 2011
Posts: 89
shabbaranks is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing columns within sheet 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
Removing columns within sheet 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
Removing columns within sheet Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft