![]() ![]() are generally entered in advance and not really part of your macro. Fixed values and static information such as names, addresses, ID numbers, etc.Spreadsheets are dynamic, which means they constantly change, which means the cell addresses change. Macros require “relative” cell addresses, which means you “point” to the cells rather than hardcode the actual (or “absolute”) cell address (such as A1, B19, C20, etc.) in the macro.You can always combine these mini-macros into one BIG macro later once they’re perfected. This is best for testing and editing (if needed). Keep your macros small and focused on specific tasks.Use the directional keys to navigate: Up, Down, Right, Left, End, Home, etc., and shortcut keys to expedite movement.Always begin your macro at the Home position (use the key combination Ctrl+ Home to get there quickly). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |