Improve company productivity with a Business Account.Sign Up

x
?
Solved

in excel what is the value of x1No

Posted on 2013-01-02
3
Medium Priority
?
700 Views
Last Modified: 2013-01-03
in a sort
.Header = x1No     (or it can be x1Yes)

does anyone know what value and type are those two?

using the sort in VBA code, if i set a break the check the values both return =empty
this seems mighty strange.

I have a input box that lets the macro user pick the sheet they want, whether there is a header on it, which column to sort and which columns to sum.

I was hoping to set the .Header in the sort with a variable.

gary
0
Comment
Question by:javagair
  • 2
3 Comments
 
LVL 77

Assisted Solution

by:GrahamSkan
GrahamSkan earned 2000 total points
ID: 38736184
You can get those values from the immediate window:
?xlyes
 1
?xlno
 2
0
 
LVL 77

Accepted Solution

by:
GrahamSkan earned 2000 total points
ID: 38736213
Ah, I see.
The second character is a lower case L, not a digit.
0
 

Author Comment

by:javagair
ID: 38741302
realized that I have typed in a 1 not a l after posting the question.
when you put in the correct letter you do get the answers posted.
it was a long day.

gary
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

With the emergence of Office 365 as a superior email communication platform, many organizations have started switching over to it.  After migrating to Office 365, sometimes users, as well as organizations, will have to import PST files to Office 36…
Debits & Credits have been the foundation of financial record keeping since 1494 - over 500 years. Excel is a brilliant tool for leveraging this ancient power - not least with Pivot Tables, sorting and filtering.  This article seeks by illustration …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question