Solved

in excel what is the value of x1No

Posted on 2013-01-02
3
656 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

622 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