0
Excel has a variation of Visual BASIC built into it, called Visual BASIC for Applications, commonly called VBA. The advantage of using VBA is that it greatly enhances what you can do with Excel. It gives you greater power to do things with Excel that are difficult or impossible with Excel formulas. It can help automate tasks by creating simple macros. It brings the powers of programming to Excel.
The main disadvantage is the complexity of VBA if you are not familiar with it. It takes time to learn how to use it, and even then it can be complicated to get it to do what you want. If you have knowledge of Visual BASIC that will help, but there are aspects of VBA that are especially for working with Excel. There is the danger to ruining your data if you do something wrong with VBA.
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What are the pros and cons of the internal combustion engine?
pros- fun cons- happy
Pros and cons of robotics?
pros ~ no salaries to pay ~ less errors ~ faster work cons ~ job displacement ~ expensive ~ can break down
What are the pros and cons of science and technology?
it have no merits only demerits
What are the pros an cons of genetic modification in human?
the world will eventually and if do this
What are the robotic pros and cons for worker displacement?
they wont cry when they are fired,
What has the author George Joseph Cons written?
George Joseph Cons has written: 'Actuality in school' 'Geography and visual education' -- subject(s): Study and teaching, Visual education, Geography
What are pros and cons of using benzene?
The pros of benzene is apple and the cons of benzene is banana.
Are weighing the pros and cons important in decision making?
Weighing the pros and cons is the most used method in decision making. By writing the pros and cons of a problem down on a piece of paper, you get a visual layout of the decision that needs to be made.
What are the pros and cons of using an HVAC system in a residential building?
pros comfort cons no comfort if you want to heat or cool you will be using some form of hvac
What are the pros n cons of science?
Science is simply a method of observation and experimentation to answer questions. There is no way to list pros and cons for such a basic idea. There can be pros and cons to specific applications of science, but not to science itself.
What are the pros and cons of using lng?
Pros green safe non corrosive odorless nontoxic CONS nonrenewable
What are the pros and cons of using gasoline powered cars?
Pros: Car moves Cons: Car pollutes atmosphere
Can you do anything about the cons of using diamonds?
You can refuse to use diamonds.
What are the pros and cons of using a market intermediary?
What are the pros and cons of using a market intermediary?
How to make sentence using pros and cons?
After weighing up the pros and cons, Albert decided against buying a new car.
What are the pros and cons of a sony digital camcorder?
The pros and cons of a Songy Digital Camcorder include the basic pros and cons of any digital camcorders. Some of the pros are the compact design and the ability to connect to a computer or a television for large-screen viewing. Some of the cons are the price and the battery life.
What cons are there to using free website designers?
The cons in using free website designers are many fold. First, there is no guarantee as to the quality and functionality of their work. Second, you do not own any of the work as you have not paid for it.
