Excel VBA Tutorial: Learn To Use VBA To Overcome Macro Recorder Limitations
Reposted from http://www.vbaclass.com/blog/excel-vba-tutorial-learn-to-use-vba-to-overcome-macro-recorder-limitations/ If you record a macro where you sort your data, the macro records the last contiguous row in the data set. Next time you run the macro, if you have more rows of data the recorded macro wont correctly sort to the new last row. Also, anytime you record a macro to […]
Excel Class Blog – Free Excel Tutorial – Excel Relative versus Absolute References
Excel Class Free Tutorial – Learn about Excel Relative and Absolute References