how to use marco in excel

[rnparikh]

is any one know how to use Marco in excel and what is benefits to use
it?
Thanks a lot

 

[Bob Phillips]

Yes we know how to use a macro, they are usually required to do something
not built into Excel. But if you don't have a use, why do you ask?

 

[CLR]

Yes rnparikh, all of the "more accomplished" Excel users are able to use
macros, and even some of us "accomplishment challanged" users are able to
muddle through them sometimes.

From one of my previous posts:
A "Macro" is an abbreviation for a set of commands, so instead of typing a
complicated sequence of commands you can simply type the Macro's name. You
can either think of Macros as new commands in their own right or as
subroutines.
Virtually anything that can be done by hand in Excel, can be written into a
"Macro" so one can only invoke the Macro when they want that particular list
of commands instead of having to type each one each time.

Basically, they are mini-programs that can greatly shorten the time of
completion of repetitive tasks, as well as accomplish some things you can't
do by hand.


Vaya con Dios,
Chuck, CABGx3

 

[RagDyeR]

You might just have completed someone's home for them!<g>

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

Yes rnparikh, all of the "more accomplished" Excel users are able to use
macros, and even some of us "accomplishment challanged" users are able to
muddle through them sometimes.

From one of my previous posts:
A "Macro" is an abbreviation for a set of commands, so instead of typing a
complicated sequence of commands you can simply type the Macro's name. You
can either think of Macros as new commands in their own right or as
subroutines.
Virtually anything that can be done by hand in Excel, can be written into a
"Macro" so one can only invoke the Macro when they want that particular list
of commands instead of having to type each one each time.

Basically, they are mini-programs that can greatly shorten the time of
completion of repetitive tasks, as well as accomplish some things you can't
do by hand.


Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Could be.............and I understand that other folks see this subject
differently...........but I don't mind. I figure if someone can find their
way here and have the ability to ask a question, they deserve the best
answer we can give them. I know plenty of folks helped me here when my
questions were similar to this one.

Vaya con Dios,
Chuck, CABGx3

You might just have completed someone's home for them!<g>

--

Regards,

RD
-------------------------------------------------------------------------- --
-------------------
Please keep all correspondence within the Group, so all may benefit !
-------------------------------------------------------------------------- --
-------------------

Yes rnparikh, all of the "more accomplished" Excel users are able to use
macros, and even some of us "accomplishment challanged" users are able to
muddle through them sometimes.

From one of my previous posts:
A "Macro" is an abbreviation for a set of commands, so instead of typing a
complicated sequence of commands you can simply type the Macro's name. You
can either think of Macros as new commands in their own right or as
subroutines.
Virtually anything that can be done by hand in Excel, can be written into a
"Macro" so one can only invoke the Macro when they want that particular list
of commands instead of having to type each one each time.

Basically, they are mini-programs that can greatly shorten the time of
completion of repetitive tasks, as well as accomplish some things you can't
do by hand.


Vaya con Dios,
Chuck, CABGx3




message news:[email protected]...

 

[Scudo]

purely as an observer ....

Its nice to get an answer that helps. 4 years ago I couldn`t switch on a PC
I discovered excel by chance and now do all my own spreadsheets, I remember
hearing words like macro and various others, out of interest I also asked
the questions...what are they? From there I played around with them and
used some in my spreadsheets, this all helped to develop my understanding of
spreadsheets, I still need help but maybe my questions are not so stupid
now. I also thoroughly enjoy photographic editing but personally don`t have
a great need for it, its fun for me. I have just spent a couple of hours
helping step by step someone who hadn`t a clue, but I enjoyed that.

I think some of us become so far advanced that even `normal` questions
become an irritation, thats not necessary a failing and those individuals
are a blessing at a higher level, unfortunately we all have to start
somewhere and I personally help others in areas that I can so be it well
below any advanced levels.

My posting is not intended to offend or attack others, its purely my
viewpoint having been there and taken the flack along the way.

Juco

 

[Bob Phillips]

Scudo,

I don't think anyone would argue with your points.

But the point RD is making, and I think I read the situation the same way
hence the obtuse ness of my reply, is that if you get a homework/coursework
question, you are meant to research it and come to some personal thoughts
based on information that you have gleaned. Just posting the question and
assembling the answers is lazy, intellectually bankrupt, and downright
dishonest. Asking a question of what is a macro and what is it for leads us
to believe that it is homework, it is too general, has no specific purpose,
etc. If I want help on photographic editing I wouldn't post a question
asking what it is, by wanting help I should know something about it, and be
able to post a smarter question.

Of course we may be wrong, but that is my view.

 

[Harald Staff]

Hi Bob

This discussion surface every 18 months or so

I'm with Chuck. Knowledge is just as much knowing where to find the
solutions, as is is going around memorizing tons of stuff. I usually err on
"Test your Excel skills" test because I don't recall the name of some rare
economical function or the exact caption of some menu item. Also, I can't
see why it's wrong to assist a pupil or a student, while it's perfectly
normal to help accountants or NASA engineers that probably are well paid to
know those things themselves.

My view only, many disagree and it's ok with me.

Best wishes Harald

 

[Bob Phillips]

Harald,

I see the difference as, with the accountant, his job is to provide the
solution, his boss doesn't care how he got there. The student's task is to
demonstrate the ability to research a topic, collate information, and then
to make a reasoned discussion. Us supplying an answer satisfies the first,
completely usurps the second. Somewhat akin to reading the results before a
test, what is the point?

--
HTH

Bob Phillips

Hi Bob

This discussion surface every 18 months or so

I'm with Chuck. Knowledge is just as much knowing where to find the
solutions, as is is going around memorizing tons of stuff. I usually err on
"Test your Excel skills" test because I don't recall the name of some rare
economical function or the exact caption of some menu item. Also, I can't
see why it's wrong to assist a pupil or a student, while it's perfectly
normal to help accountants or NASA engineers that probably are well paid to
know those things themselves.

My view only, many disagree and it's ok with me.

Best wishes Harald

Scudo,

I don't think anyone would argue with your points.

But the point RD is making, and I think I read the situation the same way
hence the obtuse ness of my reply, is that if you get a homework/coursework
question, you are meant to research it and come to some personal thoughts
based on information that you have gleaned. Just posting the question and
assembling the answers is lazy, intellectually bankrupt, and downright
dishonest. Asking a question of what is a macro and what is it for

leads

 

[Harald Staff]

Any research will result in several perfectly good answers / solutions.
Wether a student copy-pastes or understands-collates is a question of
ethics, and I will not deny her my assistance because I assume the worst.

If Chuck lent the OP a book containing the same text as his good response
contains, I don't think anyone would have objected. It is a computer thing.

But I guess this also has to do with what we provide, is it "solutions" or
is it knowledge. I try to explain wherever I can, and I try to leave the
implementation work for the OP (-you may have noticed that my code solutions
often assumes too much and have no error handler, that is intentional).

Best wishes Harald

Harald,

I see the difference as, with the accountant, his job is to provide the
solution, his boss doesn't care how he got there. The student's task is to
demonstrate the ability to research a topic, collate information, and then
to make a reasoned discussion. Us supplying an answer satisfies the first,
completely usurps the second. Somewhat akin to reading the results before a
test, what is the point?