Solved

in excel what is the value of x1No

Posted on 2013-01-02
3
644 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 76

Assisted Solution

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

Accepted Solution

by:
GrahamSkan earned 500 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

828 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