Errata

Print Print Icon

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



Version Location Description Submitted By
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 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 

"Users of the Excel program who want to move from beginning to intermediate levels without hours of study will find this handbook of over a hundred 'hacks' invaluable..."
--Diane Donovan, California Bookwatch - Computer Shelf