Hello,
Hello Subbu,
Following are few points that should be considered while recording a macro for its errorless execution.
1) While recording we recommend using more of keyboard short cuts instead of mouse clicks as they are more reliable than mouse moves/clicks irrespective of change in screen resolution or window size. Mouse clicks/moves are subject to work on a screen resolution they were recorded on. However, keystrokes will work as expected no matter whatever screen resolution you set to. For e.g. Up/Down arrow key would work in a reliable way than using mouse to scroll in an excel sheet.
2) While recording after you perform an action, wait for few seconds so that command gets enough time to execute on replay. Insufficient delay can skip any command and hence can mess up the commands. With our advanced macro product, Workspace Macro Pro 6.5, after recording, you can also edit your macro through Tools->Macro Editor to insert Delay command. You can download free version of Workspace Macro Pro 6.5 from our website:
http://www.tethyssolutions.com/macro-automation.htm
3) Here is a link to best practices for our macro products, Workspace Macro 4.6 and Workspace Macro Pro 6.5
http://www.tethyssolutions.com/bestpractices.htm
Hope that helps.