Hi, Can anyone advise the best way to learn VBA?
Is it via books? and if so what's a good one to start with?, Do I get one on one tuition?
I am a beginner in VBA, however have used excel fo 10 years or so. I am fairly conversant with formula, in that I use certain functions regularly, e.g sumproduct, vlookup, pivot tables, I can build simple macros, concatenate, replace, mid, left, right, substitute. I realise that I am only using a very, very small percant of excel capabilities, but in order to develop some ideas would love to know how the coding works, the basic blocks to start with.
Any help greatly received.
Thanks
Bookmarks