how to check excel sheet macros are working properly?

Question

1.00/5 (1 vote)

See more:

Microsoft

How to check that the macros we have applied in excel sheets is working properly????

Posted 17-Mar-11 1:02am

Member 7673456

Updated 17-Mar-11 1:29am

v2

Add a Solution

Comments

Tarun.K.S 17-Mar-11 7:15am

By executing them.

2 solutions

Solution 2

Hi ,

Adding a watch or Block of code to debug can get u intended output .
Debug also and hover on each line to know the execution value to see .

Do Reply !!!!!
Thanks

Posted 30-Nov-14 19:44pm

RavR11

Comments

OriginalGriff 1-Dec-14 5:26am

Reason for my vote of one: There is no point in digging up three-year-old questions and adding a generic and frankly not particularly helpful answer to it.
This isn't about debugging, it's about the stage before that: finding out if there are any bugs in the first place.

This kind of behaviour looks like a rep points hunt: which is a form of abuse and can result in your account here being closed. By all means answer questions, but the answers must be relevant, and they just be "I want points, and I don't care how" type answers. OK?

RavR11 12-Dec-14 5:46am

Have Good Walk !!!!!

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2011-03-17T02:00:00

Tarun.K.S.s' answer may sound flippant, but it is in fact the only way to tell.
With any form of software - and macros are a form of software - the only way to tell if it is working "correctly" (i.e. doing exactly what you intended it to do, rather than what you told it to do) is to run it and see.

" actualy its not giving any error while running......... I just wanted to test that how it works"

What kind of answer do you want? "Run the macro and make sure that cell E162 on the "Invoices" sheet contains 179.66?"

How do you expect us to answer that? We don't know what your macros do, so how could we possibly tell you how to test if they work properly? A lack of detected errors does not mean a macro works. Only you can design a test for them: we don't even know what kind of data they are manipulating!

(And that is not a hint: "post your macros" - I don't want them!)