Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hello, I obtained an .xls file that I need to do work on and at least one tab that I am working on finishes in column IA. Other tabs finish in column IV, which is the higher limit to the right for .xls files. I have converted it to .xlsx and the above did not change. How can I view up to column IV at least for the tab that goes up to IA? Thanks in advance. Demetrios
Solved by A. B. in 16 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 10/08/2018 - 02:09
Greetings! Thank you for choosing Got It Pro!
Excelchat Expert 10/08/2018 - 02:10
Can you share a screenshot of the worksheet ending in IA?
User 10/08/2018 - 02:10
User 10/08/2018 - 02:11
one second
Excelchat Expert 10/08/2018 - 02:11
User 10/08/2018 - 02:11
This one. I created a new tab and it ended in col. IA, while other tabs ended in cols IV. I changed it to .xlsx and it still shows IA
[Uploaded an Excel file]
Excelchat Expert 10/08/2018 - 02:12
Can you try pressing Ctrl+ right arrow key on your key board?
User 10/08/2018 - 02:12
Yep, it doesn't proceed further
User 10/08/2018 - 02:13
still ends there
Excelchat Expert 10/08/2018 - 02:13
Okay hold on.
Excelchat Expert 10/08/2018 - 02:13
What excel version are you using?
User 10/08/2018 - 02:14
Latest one
User 10/08/2018 - 02:14
the paid subscription
Excelchat Expert 10/08/2018 - 02:14
So 2016 yes?
User 10/08/2018 - 02:15
Thanks. Also, from the VBA window, I can't put a bigger range. See next screenshot.When I type in anything after IA, it changes back
[Uploaded an Excel file]
User 10/08/2018 - 02:15
Well, if it's not 2016, it is at least 2010
User 10/08/2018 - 02:15
It's the paid subscription, so I guess it's 2016
Excelchat Expert 10/08/2018 - 02:16
Alright. Hmm, have you tried manually inserting columns?
User 10/08/2018 - 02:16
I tried copy-pasting some columns and it gives an error as it can't go further
User 10/08/2018 - 02:16
Creating a blank file and pasting all tabs there would be troublesome as there are so many
User 10/08/2018 - 02:17
but I think then the only solution is that, and to do it by VBA
User 10/08/2018 - 02:17
Unless it's some setting in Excel which evades my current knowledge...
User 10/08/2018 - 02:18
Any other options?
Excelchat Expert 10/08/2018 - 02:20
What is the error it's giving?
User 10/08/2018 - 02:21
I don't remember, but lol, I can't even select columns for copying now
Excelchat Expert 10/08/2018 - 02:22
That's strange. As in all of my sheets I'm able to see up to column XFD
[Uploaded an Excel file]
User 10/08/2018 - 02:22
Actually, I just reopened it and, halleluja, it shows many more columns to the right
User 10/08/2018 - 02:23
Very strange bug.... But it's solved on its own
Excelchat Expert 10/08/2018 - 02:23
Oh, then it's probably because of the existing excel files open.
Excelchat Expert 10/08/2018 - 02:23
Exactly. Which is great for us!
User 10/08/2018 - 02:23
No, it's the only one I had open
User 10/08/2018 - 02:23
Anyway, many thanks for being there.
Excelchat Expert 10/08/2018 - 02:23
I am glad to be of help.
Excelchat Expert 10/08/2018 - 02:24
You can now end the chat session by clicking on the button of the same name.
User 10/08/2018 - 02:24
My suggestion would be to copy the whole workbook by VBA, if anyone asks the same
User 10/08/2018 - 02:24
tab by tab
User 10/08/2018 - 02:24
If it doesn't solve itself automatically
Excelchat Expert 10/08/2018 - 02:24
That would be true but we don't support VBA as of yet.
User 10/08/2018 - 02:24
OH, ok
Excelchat Expert 10/08/2018 - 02:25
So we're limited to spreadsheets really.
Excelchat Expert 10/08/2018 - 02:25
But yes, that's one of the best options.
Excelchat Expert 10/08/2018 - 02:25
In any case. Looking forward to helping you again for your spreadsheet needs!
Excelchat Expert 10/08/2018 - 02:25
Have a great day!
User 10/08/2018 - 02:25
Thanks. Thanks again!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc