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).First, some tips on how to prepare your data for macros:
0 Comments
Leave a Reply. |