<t>Quote--------------------------------------------------------------------------------Originally posted by dirtydroogwhere i work hungarian notation is explicitly banned--------------------------------------------------------------------------------Wow. What the logic behind that decision? Do you ...

<t>I see the English form of GIORNI.CED.NUOVA() is CoupDayBS()Now it runs..... Not sure what supposed to come out - where. Add some comments and I'll have another look.A couple of general comments,1 All the initial set-up should be out-of-way at the end. Call a routine called "set-up" then get to th...

<t> GIORNI.CED.NUOVA(R[-4]C,R[-3]C,R[-2]C,R[-1]C)"Shouldn't fail - even in Italian. Where is it defined? If if the function only determines the number of days between two dates why do you need a special function?Without comments you would need to be a masochist to do much more digging. I think you n...

<t>The line that writes 39649 into your B column is Cells(j - Date, 2) = j in SUB Op2The value is in fact the current date.To get any further I would need to know what is happening - i.e. the code should have a few comments!For me the line below fails. Do I need an Add-in?Range("b37").FormulaR1C1 = ...

Unkpath,Can you email the solutions to dwaring@shb.com.sa? If not, email me and I'll send you my London postal address.Many Thanks.

A large drawback to the Etheridge book is that solutions to the exercises are only available to "bona fide" teachers!

Quotedoes it cover implementation and theories?Not 100% sure what you are asking but the book is very practical with numerous spreadsheets with names like CDO Pricer.xlsRegards

<t>I bought this book a few days ago as an introduction to a subject I should know more about.Having since skimmed through the pages it looks promising. The only complaint I have is that no solutions are provided to the interesting exercises sprinkled throughout the book. I will never understand why...

<t>Hi all,I bought this book without seeing it as it appeared from the title and contents to be exactly what I was looking for.Having received it I am only disappointed that the very good exercises at the end of each chapter have NO MODEL SOLUTIONS. This is extremely frustrating when you are doing s...

Many thanks again.Downloaded - installed and using mz-tools. Very impressive.Regards,

Many thanks Sjoo,Downloaded and tried it. Looks good so far.Do you also know of a VBA equivalent of "Lint" for C++ which checks for declared variables that are unused etc?Regards,David

<t>Does anyone know of a utility that can be used to produce formatted listing from Excel's VBA modules?Ideally, all subroutines and functions should start on a new page, comments should be tab aligned, a proportional font should be used etc. etc.I know utilities are available for C/C++ but I've nev...

Of course, 1.75 inches refers to the PRM manual for exam 1 only.regards

If you print it on double sided paper, you end up with about 1.75 inches of paper! (Page count is difficult as pages are not continuios)Its a great manual, my only comment is that it would be even better with exercises!Regards,

Hi,I agree the TOC is impressive. Bought Professional Excel Development on that alone last week. So far so good but, as it states in the Intro, the reader is expected to have read and mostly understood Excel VBA Programmers Reference or similar.