tags:

views:

48

answers:

1
Q: 

What is &H20 and &HDF in VBA?

I am trying to grok the following piece of code:

Mid$(strV, i, 1) = Chr$(intChar And &HDF)

What does &HDF mean? I also have a similar section that uses @H20. I have Googled high and low and the most I found was nothing that I didn't already know about them...that they are constants.

+1  A: 

That Visual Basic's hex notation. In C/C++/Java/C#, &HDF would be written as 0xDF.

Specifically, in your example, &HDF is 1101 1111 in binary. If a number in the range 0-255 (i.e., 0x00 - 0xFF) is ANDed with 0xDF, the 0x20 bit is set to zero. If that number happened to be in the range 97 - 122 (i.e. 'a' - 'z' in ASCII), it has the effect of converting it to the range 65 - 90 ('A' - 'Z' in ASCII)

James Curran  2010-09-15 19:00:15
In other words, it's probably a really cryptic way to convert a specific lowercase letter to an uppercase letter within another string. I would probably have used the UCase and LCase functions, but they may have some other function we aren't seeing.
KevenDenen  2010-09-15 20:37:24
Well, it is very fast --- if you can guarantee that the only characters it sees are letters. Digits and punctuation reak havoc with it (a space becomes `Chr$(0)`)
James Curran  2010-09-15 20:49:40

related questions

How can I refresh all the pivot tables in my excel workbook with a macro?
MS Access - Controlling another database in VBA
Deleting a file in VBA
How do you prevent printing dialog when using Excel PrintOut method
SQLite UDF - VBA Callback
Function Overloading in Excel VBA
How do I keep RecipientTime when executing MailItem.Move in an Outlook macro?
How do I assign a keyboard shortcut to a VBA macro in Outlook 2007?
Visual studio automation: Enumerate opened windows upon solution loading.
Hiding data points in Excel line charts
How do I create a status dialog box in Excel
Modifying a spreadsheet using a VB macro
Count a list of cells with the same background color
Templates In VB
Best way to test a MS Access application?
How do I read/write Person metadata from a Word doc stored in SharePoint using VBA or VSTO?
Excel VBA: Alternative IDE
good directory picker for visual basic macros in MS Outlook (2007)
Zoom for a windows form in C#
Excel: list ranges targeted by INDIRECT formulas
What is the best way to package and distribute an Excel application.
Alternating coloring groups of rows in Excel
Word Automation: Write RTF text without going through clipboard
How to parse XML in VBA
Refresh Excel VBA Function Results