- Always begin one step behind.
Example: If you wish to select sheet1 for every playback then before recording start you must select other sheets, same goes to range. - If you use formula inside your macro then it is better to remove this formula by copy and paste value
- If you wish to fill certain range with formula or data use short cut key Ctrl(hold) + Enter(Followed)
- To select certain range in column always use short cut key Ctrl(Hold) + Shift(Hold) + arrow right(Followed)
- To select certain range in row always use short cut key Ctrl(Hold) + Shift(Hold) + arrow down(Followed)
- To select certain range for all always use short cut key Ctrl(Hold) + Shift(Hold) + End(Followed)
- Start and End with selecting Range A1
- Minimize the usage of scroll it will occupied your code for nothing
- Standardize sheets name
- Plan your recording step
Good Luck
Click here if you have any new project! Let us create for u for free.
No comments:
Post a Comment