Errata

Excel Hacks

Errata for Excel Hacks

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
Printed Page 24
in the Visual Basic Code

In Line 3 the code is "Dim 1 As Long"
In Line 4 " " " "1 = 1"

But the second "1" in Line 4 is a smaller size than the first "1" in this line and in Lin two.

When I type in a normal "1" or subtitue it for an l (L lower case, I get an error in the code.

Is there something I am missing or is this code wrong?

Anonymous   
Printed Page 202
Figure 6-6. Date formats converted to valid dates (U.S. format)

1. Formula used in column B cannot possibly give the correct New Dates in column C;
2. In fact, the formula used will only give #VALUE errors.
3. Moreover, the formula used are identical to those in Figure 6-7. Date formats converted to valid dates
(European format)- and that's why they are wrong!

The question that begs to be answered, then, is: How can the formula used in column B produced the dates
shown in New Date column C in a SCREEN SHOT of the worksheet?

 Anonymous   
Printed Page 207
in the tip paragraph

The tip refers back to hack 78 (a date hack) when it should point to hack 79 (DSUM hack) instead.

 Anonymous   
Printed Page 207
Tip

Reference is to DSUM function described in "Convert Dates to Excel Formatted Dates" Hack # 78.
There is no DSUM function in Hack #78, should the reference be to "Sum or Count Cells While Avoiding Error Values" Hack #79 ?

 David Garrod  Mar 30, 2012 
Printed Page 319
Compile error on the code: line 12

I was trying to run your macro on Sorting Worksheets, but everytime I try to running it, VB prompts : Compile error: Variable not defined and it highlights: "lCount2" on the "For lCount2 = lCount To lShtLast" line.

I put the whole code on a new module on the workbook.

 Anonymous