Excel VBA
- Thread starter Tarun.M
- Start date
shrivallabha
Excel Ninja
1. You can start yourself with a macro recorder. Whenever you are not sure about the VBA code then just record your actions using macro recorder and study them. After studying them (at beginning line by line and later by experience), you will be able to remove unwanted code.
2. Buy some good books that let you understand the concepts in a systematic manner.
a. Excel VBA and Macros by Bill Jelen
b. Power Programming with VBA by John Walkenbach
3. Read online stuff that is available which is huge. These sites have enormous amount of data so you can search items by googling.
Main thing will always be practice and your personal time. Wish you good luck!!!
2. Buy some good books that let you understand the concepts in a systematic manner.
a. Excel VBA and Macros by Bill Jelen
b. Power Programming with VBA by John Walkenbach
3. Read online stuff that is available which is huge. These sites have enormous amount of data so you can search items by googling.
Main thing will always be practice and your personal time. Wish you good luck!!!
Tarun.M
This has been discussed here at Chandoo.org several times
You may also want to read these post and associated comments:
http://chandoo.org/forums/topic/if-i-take-chandoos-vba-course
http://chandoo.org/wp/2011/08/29/introduction-to-vba-macros/
http://chandoo.org/wp/2011/09/06/top-10-tips-for-excel-vba/
This has been discussed here at Chandoo.org several times
You may also want to read these post and associated comments:
http://chandoo.org/forums/topic/if-i-take-chandoos-vba-course
http://chandoo.org/wp/2011/08/29/introduction-to-vba-macros/
http://chandoo.org/wp/2011/09/06/top-10-tips-for-excel-vba/
shrivallabha
Excel Ninja
Read Hui's 3rd link thoroughly and it should get you underway.
The other great thing about VBA is you can be intuitive about terminology. A column is a column in VBA and a row is a row, now isn't that simple? You can easily search items at fair clip in object browser [by hitting F2 in Visual Basic Editor Window].
As for your question, try:
To select columns A to C at a time
Note To becomes : in VBA.
The other great thing about VBA is you can be intuitive about terminology. A column is a column in VBA and a row is a row, now isn't that simple? You can easily search items at fair clip in object browser [by hitting F2 in Visual Basic Editor Window].
As for your question, try:
To select columns A to C at a time
Code:
Range("A:C,").Select
To select Array of non-contiguous columns use comma approach as we do in printing
Range("A:C,F:H,K:L").SelectNote To becomes : in VBA.