Bump this thread when you fix a bug

was going to post some Excel VBA mysteries/irritations but really Excel VBA is one big bug in itself

nevertheless, it is the only thing I can do that nobody else in the office has ever wanted to dirty their brain by looking into

(most annoying this week: using Application.Workbooks.OpenText to open a text file, specifying all the parameters, except if the file extension is .csv Excel overrides them without telling you. So I'm going to have to write some documentation that says "look, I know the file is a .csv file, but please call it .txt or anything except .csv or it will load wrongly in a way that you may not notice until it's too late")

how long will it take to learn that the problem may be in the data and not the programming... 2 hours of trying to locate an extra space in a string..............urgh

strange things on the interweb:

SELECT ThePerfectWoman
FROM AllTheWomenInTheWorld
WHERE HerInterests Like Mine
AND CurrentMate Is Null
AND CurrentlyLives IN ('Yonkers', 'Bondi Beach', 'São Paulo')
GROUP BY CASE WHEN AsManyAsWillHaveMe>AsManyAsMyStaminaWillAllow
THEN AsManyAsWillHaveMe ELSE AsManyAsMyStaminaWillAllow * 2 END
HAVING Max(Libido)>=Mine

lol, yonkers