Excel User Defined Function (UDF) Calls A Macro To Change A Value In Another Cell According to Excel’s ‘rules’ a UDF should not be allowed to change values in other cells. If you are like me, you might hate it when someone says “It can’t be done”. I tend to follow a contrarian viewpoint, and …
Category: Excel Class
Excel Class VBA Macro Adds IfError Functions To Every Formula Today a student asked Excel Class if there was a macro to automatically add an IfError function to every formula on every sheet in a selected workbook, assuming there was not already an IfError function used. On short notice the Excel Class instructor provided the …
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 …
Few things in life are constant. Heraclitus said: The only thing constant is change. Change is constant and variables are used to capture change. In the context of Excel, the names of workbooks change, the number of workbooks you have open is variable, the number of sheets, pivot tables and charts is usually variable, the name of sheets is variable, the values in cells are variable, and on, and on.
Excel Class is pleased to announce our Q1 2011 Excel VBA Classes schedule. Philadelphia, PA February 16th – 18th – Register Here Boston, MA February 23rd – 25th – Register Here Baltimore, MD March 1st – 3rd – Register Here Miami, FL March 7th – 9th – Register Here Atlanta, GA March 16th – 18th …