|
how to use marco in excel
is any one know how to use Marco in excel and what is benefits to use it? Thanks a lot -- rnparikh ------------------------------------------------------------------------ rnparikh's Profile: http://www.excelforum.com/member.php...o&userid=25737 View this thread: http://www.excelforum.com/showthread...hreadid=391490 |
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? -- HTH Bob Phillips "rnparikh" wrote in message ... is any one know how to use Marco in excel and what is benefits to use it? Thanks a lot -- rnparikh ------------------------------------------------------------------------ rnparikh's Profile: http://www.excelforum.com/member.php...o&userid=25737 View this thread: http://www.excelforum.com/showthread...hreadid=391490 |
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 "rnparikh" wrote in message ... is any one know how to use Marco in excel and what is benefits to use it? Thanks a lot -- rnparikh ------------------------------------------------------------------------ rnparikh's Profile: http://www.excelforum.com/member.php...o&userid=25737 View this thread: http://www.excelforum.com/showthread...hreadid=391490 |
You might just have completed someone's home for them!<g
-- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "CLR" wrote in message ... 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 "rnparikh" wrote in message ... is any one know how to use Marco in excel and what is benefits to use it? Thanks a lot -- rnparikh ------------------------------------------------------------------------ rnparikh's Profile: http://www.excelforum.com/member.php...o&userid=25737 View this thread: http://www.excelforum.com/showthread...hreadid=391490 |
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 "RagDyeR" wrote in message ... You might just have completed someone's home for them!<g -- Regards, RD -------------------------------------------------------------------------- -- ------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------------- -- ------------------- "CLR" wrote in message ... 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 "rnparikh" wrote in message ... is any one know how to use Marco in excel and what is benefits to use it? Thanks a lot -- rnparikh ------------------------------------------------------------------------ rnparikh's Profile: http://www.excelforum.com/member.php...o&userid=25737 View this thread: http://www.excelforum.com/showthread...hreadid=391490 |
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 "CLR" wrote in message ... 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 "RagDyeR" wrote in message ... You might just have completed someone's home for them!<g -- Regards, RD -------------------------------------------------------------------------- -- ------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------------- -- ------------------- "CLR" wrote in message ... 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 "rnparikh" wrote in message ... is any one know how to use Marco in excel and what is benefits to use it? Thanks a lot -- rnparikh ------------------------------------------------------------------------ rnparikh's Profile: http://www.excelforum.com/member.php...o&userid=25737 View this thread: http://www.excelforum.com/showthread...hreadid=391490 |
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. -- HTH Bob Phillips "Scudo" wrote in message o.uk... 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 "CLR" wrote in message ... 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 "RagDyeR" wrote in message ... You might just have completed someone's home for them!<g -- Regards, RD -------------------------------------------------------------------------- -- ------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------------- -- ------------------- "CLR" wrote in message ... 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 "rnparikh" wrote in message ... is any one know how to use Marco in excel and what is benefits to use it? Thanks a lot -- rnparikh ------------------------------------------------------------------------ rnparikh's Profile: http://www.excelforum.com/member.php...o&userid=25737 View this thread: http://www.excelforum.com/showthread...hreadid=391490 |
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" skrev i melding ... 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. -- HTH 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 "Harald Staff" wrote in message ... 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" skrev i melding ... 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. -- HTH Bob Phillips |
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 "Bob Phillips" skrev i melding ... 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 "Harald Staff" wrote in message ... 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" skrev i melding ... 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. -- HTH Bob Phillips |
| All times are GMT +1. The time now is 05:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com