Creating a series of named ranges though VBA in a fast way

You can try to export this macro. May be it will work correct, may be not ))) depends on file.
About basic VBA I can`t suggest smthng exactly. May be http://www.excel-easy.com/vba.html