OK so you're not that bad at VBA.
You've got many years of "basic", self taught, computer programming in Basic, C++, Fortran etc
You're boss is very impressed with the recent Macros you've managed to write (with help from this Forum)
And now you want to branch out.
I need guidance, firstly where can I get a good book on programming architecture/methodology? I know I can buy hundreds of books on how to program in C, C++, VBA etc but where are the books that teach you how to structure your program? how to perform a "bubble sort" etc, what is good and bad methodology, is it ever acceptable to use 'goto'?
The second is with VBA, from working through the recent macros I have written, I find that my biggest weakness is working with unknown ranges. For example most of my macros are based around stock lists that vary in length by day, let alone by week, so I cannot say select A1 to Z555 as tomorrow it may be A1 to Z1000.
Any advice as what books I should purchase to cover the above topics would be greatly appreciatted, if they were available in the UK that would be even better.
Thanx in advance