Attempt to export a VBA module, which moves active cell down one square in Excel
Copy modules from VBA.txt into Excel Macros
Then use keyboard shortcut Ctrl + d to run macro to move active cell down by one
Recommended shortcuts: - go into Macros - Options - set shortcuts: - up = Ctrl + r - down = Ctrl + f - left = Ctrl + d - right = Ctrl + g
if this fails click on macro / module named down() to run
was only working on single digit rows - use ActiveCell.Row instead of: Right(live_cell, 1)
only works on single letter columns currently
active cell - down.txt has module to move active cell down by 1 - up.txt has module to move active cell up by 1 - also has comments
How can I export VBA code to text from de modules?
vba active cell increment cell value by one increment string character by one string manipulation string to number concatenate integer to string vba active cell get selected rows VBA – Get the Active Cell’s Column or Row How To Automatically Increase Letter By One To Get The Next Letter In Excel? Excel VBA - increment column reference in range VBA – Get the Active Cell’s Column or Row