Business and Productivity Software
Problem for Microsoft Business and Productivity Software
Generic problem for all Microsoft Business and Pro...

Need a link




By harsh_stars on Jun 20, 2008

" "
actually i want to learn macros in excel.... can u pls suggest me a site where i can learn... i m a starter n dont know a word....

Solution #1

posted on Jun 27, 2008
Not Rated)

ke5uyx

Rank: Guide 
Rating: 75%, 6 votes
Macros are harder to understand than they are to create and use. Let me repeat "Macros are harder to understand than they are to create and use."
Here is the only understanding that you need. "they are used for repetive tasks" .

Now to the simple part of creating then using.
Get into your work and identify a task that you want to created macro for, Kapish? Just before you start on the task go into the macros screen and tell it to "create", then do your task. When through "push the stop button. Name the micro and save it. (the name may be the first step if so then give the darn thing a name, no big deal). The next time you are in the exact field where the identical task is going to be perforned you can call up the micro to run through the key strokes for you. Get ready for wildly unexpected results, with those understood you can go into the code and modify it. Or you can delete it and create anotherone that is cleaner. Keep doing this until you get the bugs out. By the way the once created micros leave a tag in the spreadsheet that alerts everyone that opens it to watch out for the dreaded micro you created.
Was this helpful?
Yes
No

Popular Solutions for Business and Productivity


Questions and Unsolved Problems for Business and Productivity


Answer
How can I format a 16 digit credit card number to display and print with the first 12 digits as a... (More)

Answer
security has a red x and will not fix itself & Norton says it is not their problem &... (More)

Answer
My word documents are locked, I don't remember ever loading a trial version of XP but that looks... (More)

Answer
When I cut and paste in label, the contents get divided between all the label boxes instead of the... (More)


Didn't find what you were looking for?

Describe your problem:

Select a Category:







Ask our Experts

 

Solve Your Problem Now!
Chat Live with an Expert
Chat Now
Top Business and... Experts



Top Computer & Laptop Repair
(877) 729-0812
We connect to your computer over the Internet to...
Remote Repair

(952) 890-7770
Zkarlo.com provides discount and used laptop parts...
Zkarlo.com



       
Solve Your Problem Now!
Chat Live with an Expert
Chat Now

Insert Link
Insert Image
Insert You-Tube clip
Insert List
Insert List
Spell Check

What is this?



Select